- NuGet搜索Free Spire.XLS安装,添加命名空间:using Spire.Xls;
读取加密xlsx或xls文件:
Workbook workbook = new Workbook();
workbook.OpenPassword = "password";
workbook.LoadFromFile("input.xlsx");
Worksheet sheet = workbook.Worksheets[0];
//......
workbook.SaveToFile("output.xlsx", ExcelVersion.Version2013);
- 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文档
}
}
}
- 打开文件之前加一句
Biff8EncryptionKey.CurrentPassword="密码"
读取xls文件用HSSF,xlsx文件用XSSF