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(); } }