開啟加密excel 和 自訂c#dll目錄

標籤：name   xss   new   定義   end   orm   tor   oid   return   

POIFSFileSystem pfs = newPOIFSFileSystem(POIDataSamples.getPOIFSInstance().openResourceAsStream("yourexcelfile.xlsx")); 
EncryptionInfo encInfo = new EncryptionInfo(pfs); 
Decryptor decryptor = new Decryptor(encInfo); 
decryptor.verifyPassword("ABCXYZ"); 
XSSFWorkbook wb = new XSSFWorkbook(decryptor.getDataStream(pfs));

 

開啟加密excel。

 

自訂dll目錄

 

        private void Form1_Load(object sender, EventArgs e)        {            AppDomain.CurrentDomain.AssemblyResolve += new ResolveEventHandler(CurrentDomain_AssemblyResolve);        }        static Assembly CurrentDomain_AssemblyResolve(object sender, ResolveEventArgs args)        {            AssemblyName assemblyName = new AssemblyName(args.Name);            return Assembly.LoadFrom(Path.Combine(Application.StartupPath, "3rdLibs"));        }

 

開啟加密excel 和 自訂c#dll目錄