设置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);
    }
}

 

转载于:https://www.cnblogs.com/wangyz/archive/2011/08/29/2157194.html