public ApiResponse impoetExcelKai()
{
try
{
string importExcelPath = "kaisheng.xlsx";
FileStream fsr = new FileStream(importExcelPath, FileMode.Open);
IWorkbook workbook = WorkbookFactory.Create(fsr);
ISheet sheet = workbook.GetSheetAt(1);//获取第一个工作薄
/*IRow row = (IRow)sheet.GetRow(1);//获取第一行
string s = row.GetCell(4).ToString();*/
int num = sheet.LastRowNum+1;//每个sheet内有多少行
return new ApiResponse(num);
}
catch (Exception ex) { throw new ApiException(ex.Message); }
}
C# 读取excel文件
最新推荐文章于 2024-04-11 13:59:26 发布