C# 读取Excel
需要安装三个库
1.OfficeOpenXml.Core.ExcelPackage
2.OfficeOpenXml.Extends
3.EPPlus
selectedFiles = @"F:\20230720.xlsx":
FileStream stream = File.OpenRead(selectedFiles);
OfficeOpenXml.ExcelPackage.LicenseContext = OfficeOpenXml.LicenseContext.NonCommercial;
ExcelPackage package = new ExcelPackage(stream);
stream.Close();
ExcelWorksheet sheet1 = package.Workbook.Worksheets[0];
int rowNum = sheet1.Dimension.Rows;
三个库都要装不然可能会报错:
1.执行写入操作时发生磁盘错误
2.OfficeOpenXml.LicenseException:“Please set the ExcelPackage.LicenseContext"
3.关键代码:
OfficeOpenXml.ExcelPackage.LicenseContext = OfficeOpenXml.LicenseContext.NonCommercial;