#Excel文件内容保存#
System.IO.Stream MyStream = file.OpenReadStream();
//打开Excel
IWorkbook workbook = WorkbookFactory.Create(MyStream );
//获取Sheet
ISheet sheet = workbook.GetSheetAt(0);
//获取行迭代器
IEnumerator rows = sheet.GetRowEnumerator();
//跳转到第10行
ImportExcelUtil.JumpRows(rows, 10);
int rowIndex = 0;
//定义列
int colCode = 1; //编码
int colEnd = 2; //结束列
while (rows.MoveNext()) //移动到下一行
{
//获取当前行
var row = (IRow)rows.Current;
//检查数据是否读完
if (!ImportExcelUtil.CheckValidDataRow(row, colCode, colEnd))
{
break; //边界
}
//行号++
rowIndex++;
//获取第一列内容
string code = ImportExcelUtil.GetCellStringValue(row.GetCell(colCode));
}