using NPOI.HSSF.UserModel;
........
//获取第一个文件
FileStream fileOne = new FileStream(Server.MapPath(fileName), FileMode.Open, FileAccess.Read);
//生成Excel对象
HSSFWorkbook wbOne = new HSSFWorkbook(fileOne);
//读取第一个表格,索引从0开始
HSSFSheet sheet = (HSSFSheet)wbOne.GetSheetAt(0);
//获取列数量
int rowCount = sheet.LastRowNum;
//获取第三行数据
HSSFRow rowOne = (HSSFRow)sheet.GetRow(2);
JArray result = new JArray();
//这个i是从哪边开始取数据,索引从0开始
for (int i = 3; i <= rowCount; i++)
{
//获取指定行
HSSFRow row = (HSSFRow)sheet.GetRow(i);
//获取指定列,索引从0开始
//读取第一列值
HSSFCell cell = (HSSFCell)row.GetCell(1);
String information = cell == null ? "" : cell.ToString();
//读取第二列值
cell = (HSSFCell)row.GetCell(2);
String quesType = cell == null ? "" : cell.ToString();
}
asp.net C# NPOI 读取 Excel 文件
最新推荐文章于 2022-06-08 22:00:00 发布