NPOI | 读取带密码保护的excel文件

1. NuGet搜索Free Spire.XLS安装，添加命名空间：using Spire.Xls;

Workbook workbook = new Workbook();
workbook.OpenPassword = "password";
workbook.LoadFromFile("input.xlsx");
Worksheet sheet = workbook.Worksheets[0];
//......
workbook.SaveToFile("output.xlsx", ExcelVersion.Version2013);

1. spire.xls.dll的读取方法：

using Spire.Xls;
namespace ReadWordbook_XLSX
{
    class Program
    {
        static void Main(string[] args)
        {
            Workbook workbook = new Workbook();
            workbook.OpenPassword = "123";//文档密码
            workbook.LoadFromFile("Sample.xlsx", ExcelVersion.Version2013);//加载excel文档
        }
    }
}

1. 打开文件之前加一句

Biff8EncryptionKey.CurrentPassword="密码"