设置Excel文档的ADRMS权限的工具类

设置Excel文档权限的工具类

 

引用Microsoft Office 12.0 Object Library

引用Microsoft Excel 12.0 Object Library

 

 

/// <summary>
    /// 设置Excel文档权限的工具类
    /// </summary>
    public class RmsExcelHelper : IDisposable
    {
        /// <summary>
        /// Excel应用程序对象
        /// </summary>
        private Microsoft.Office.Interop.Excel.ApplicationClass app;

        /// <summary>
        /// Excel文档路径
        /// </summary>
        private string filePath;
        public string FilePath
        {
            get { return this.filePath; }
            set { this.filePath = value; }
        }

        /// <summary>
        /// 权限集合
        /// </summary>
        private List<RmsExcelPermission> rmsPerms = new List<RmsExcelPermission>();
        public List<RmsExcelPermission> RmsPerms
        {
            get { return this.rmsPerms; }
        }

        /// <summary>
        /// 空值
        /// </summary>
        private object MISSINGVALUE = System.Reflection.Missing.Value;

        /// <summary>
        /// 错误消息
        /// </summary>
        public string ErrMessage = string.Empty;

        
        /// <summary>
        /// 是否xlsx文档
        /// </summary>
        private bool is2007()
        {
            bool result = false;

            result = System.IO.Path.GetExtension(this.filePath).ToLower() == "xlsx";

            return result;
        }

        /// <summary>
        /// Rms授权后的文件名
        /// </summary>
        private string GetRmsFileName()
        {
            string filename = string.Empty;

            filename = System.IO.Path.Combine(System.IO.Path.GetDirectoryName(this.filePath), System.IO.Path.GetFileNameWithoutExtension(this.filePath) + "_RMS" + System.IO.Path.GetExtension(this.filePath));

            return filename;
        }

        /// <summary>
        /// 保存
        /// </summary>
        public bool Save()
        {
            //清除错误消息
            this.ErrMessage = string.Empty;

            bool result = false;

            string filename_src = this.filePath;
            string filename_dst = this.GetRmsFileName();

            try
            {
                if (this.app == null)
                {
                    this.app = new Microsoft.Office.Interop.Excel.ApplicationClass();
                }

                var doc = this.app.Workbooks.Open(filename_src, MISSINGVALUE, MISSINGVALUE, MISSINGVALUE,
                                                     MISSINGVALUE, MISSINGVALUE, MISSINGVALUE, MISSINGVALUE,
                                                     MISSINGVALUE, MISSINGVALUE, MISSINGVALUE, MISSINGVALUE,
                                                     MISSINGVALUE, MISSINGVALUE, MISSINGVALUE);

                try
                {
                    doc.Activate();

                    doc.Permission.Enabled = true;

                    foreach (var permission in this.rmsPerms)
                    {
                        doc.Permission.Add(permission.UserId, permission.Perms, MISSINGVALUE);
                    }

                    doc.SaveAs(filename_dst, MISSINGVALUE, MISSINGVALUE, MISSINGVALUE,
                               MISSINGVALUE, MISSINGVALUE, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange,
                               MISSINGVALUE, MISSINGVALUE, MISSINGVALUE, MISSINGVALUE, MISSINGVALUE);

                    result = true;

                }
                finally
                {
                    doc.Close(MISSINGVALUE, MISSINGVALUE, MISSINGVALUE);
                }
            }
            catch (Exception ex)
            {
                this.ErrMessage = ex.Message;
            }

            return result;
            
        }

        /// <summary>
        /// 退出Excel应用程序
        /// </summary>
        public void Dispose()
        {
            if (this.app != null)
            {
                this.app.Quit();
                this.app = null;
            }
        }
    }

    public class RmsExcelPermission
    {
        public string UserId;
        public Microsoft.Office.Core.MsoPermission Perms;
    }

 

使用示例

 

using (RmsExcelHelper helper = new RmsExcelHelper())
{
    helper.FilePath = filePath;
    helper.RmsPerms.Add(new RmsExcelPermission() { UserId="Everyone", Perms= Microsoft.Office.Core.MsoPermission.msoPermissionRead });

    if (helper.Save())
    {
        MessageBox.Show("ok");
    }
    else
    {
        MessageBox.Show(helper.ErrMessage);
    }
}