/// <summary> /// Process workbook (go through the all sheets and /// </summary> /// <param name="workbook">the workbook</param> /// <param name="workingDirectory">directory</param> public static IProcessWorkbookResult ProcessWorkbook(IWorkbook workbook) { var result = new ProcessWorkbookResult(); // go through the all sheets for (int i = 0; i < workbook.NumberOfSheets; i++) { var sheet = workbook.GetSheetAt(i); result.SheetToCsvModels.Add(ProcessSheet(sheet)); // and process this sheet (create csv file) } return(result); }
/// <summary> /// Process workbook (go through the all sheets and /// </summary> /// <param name="workbook">the workbook</param> /// <param name="workingDirectory">directory</param> public static IProcessWorkbookResult ProcessWorkbook(IWorkbook workbook) { var result = new ProcessWorkbookResult(); // go through the all sheets for (int i = 0; i < workbook.NumberOfSheets; i++) { var sheet = workbook.GetSheetAt(i); result.SheetToCsvModels.Add(ProcessSheet(sheet)); // and process this sheet (create csv file) } return result; }