public static void ImportExcel(ISheet sheet, int firstRowNum, int lastRowNum, ExcelRowProcessHandler rowHandler)
{
if (firstRowNum == -1)
{
firstRowNum = sheet.FirstRowNum;
}
if (lastRowNum == -1)
{
lastRowNum = sheet.LastRowNum;
}
for (int i = firstRowNum; i < lastRowNum; i++)
{
IRow row = sheet.GetRow(i);
rowHandler(row);
}
}
public static void ImportExcel(FileStream fs, string fileType, string worksheetName, int firstRowNum, int lastRowNum, ExcelRowProcessHandler rowHandler)
{
IWorkbook workbook;
if (fileType == ".xlsx")
{
workbook = new XSSFWorkbook(fs);
}
else if (fileType == ".xls")
{
workbook = new HSSFWorkbook(fs);
}
else
{
workbook = null;
}
if (workbook == null)
{
return;
}
ExcelHelper.ImportExcel(workbook, worksheetName, firstRowNum, lastRowNum, rowHandler);
}
public static void ImportExcel(IWorkbook workbook, string worksheetName, int firstRowNum, int lastRowNum, ExcelRowProcessHandler rowHandler)
{
ISheet sheet = workbook.GetSheet(worksheetName);
if (sheet == null)
{
return;
}
ExcelHelper.ImportExcel(sheet, firstRowNum, lastRowNum, rowHandler);
}
public static void ImportExcel(string fileName, string worksheetName, int firstRowNum, int lastRowNum, ExcelRowProcessHandler rowHandler)
{
if (rowHandler == null)
{
return;
}
using (FileStream fs = new FileStream(fileName, FileMode.Open, FileAccess.Read))
{
string fileType = Path.GetExtension(fileName).ToLower();
ExcelHelper.ImportExcel(fs, fileType, worksheetName, firstRowNum, lastRowNum, rowHandler);
fs.Close();
}
}
