使用EPPLUS的受密码保护的Excel下载 [英] Password Protected Excel Download using EPPLUS

问题描述

我正在使用 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);

这篇关于使用EPPLUS的受密码保护的Excel下载的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！