使用EPPLUS的受密码保护的Excel下载

本文介绍了使用EPPLUS的受密码保护的Excel下载的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在使用 EPPLUS Excel库以Excel格式导出数据.我希望在excel下载后会要求输入密码.我尝试了以下代码.

I am exporting data in Excel form using EPPLUS Excel Library. I want that when excel downloaded it will ask for password. I have tried following code.

FileInfo newFile = new FileInfo("sample.xlsx"); using (ExcelPackage package = new ExcelPackage(newFile) { ExcelWorksheet ws = package.Workbook.Worksheets.Add("demo"); ws.Cells[A1].LoadFromDataTable(dataTable, false); package.Workbook.Protection.SetPassword("EPPLUS"); package.Save(); }

推荐答案

只需使用.Save重载和密码作为选项:

Just need to use the .Save overload with a password as the option:

package.Save("password");

回复评论

要应用密码(如果通过byte数组进行保存)，该密码非常相似:

To apply a password if saving via a byte array it is very similar:

Byte[] bin = pck.GetAsByteArray("password"); System.IO.File.WriteAllBytes(fullFilePath, bin);