static IWorkbook CreateWorkbook(Workbook workbook, ExcelVersion version) { IWorkbook iWorkbook; switch (version) { case ExcelVersion.Xls: iWorkbook = new HSSFWorkbook(); break; case ExcelVersion.Xlsx: iWorkbook = new XSSFWorkbook(); break; default: throw new InvalidEnumArgumentException("version", (int)version, version.GetType()); } AddNames(iWorkbook, version, workbook.Names.ToArray()); foreach (Worksheet worksheet in workbook.Worksheets) { ISheet sheet = iWorkbook.CreateSheet(worksheet.Name); AddValidations(sheet, version, worksheet.Validations.ToArray()); AddRows(sheet, worksheet.Rows.ToArray()); if (worksheet.IsHidden) { iWorkbook.SetSheetHidden(worksheet.Index, SheetState.Hidden); } } return(iWorkbook); }
static int GetMax(RowColumn rowColumn, ExcelVersion version) { switch (rowColumn) { case RowColumn.Row: switch (version) { case ExcelVersion.Xls: return(RowMaxXls); case ExcelVersion.Xlsx: return(RowMaxXlsx); } break; case RowColumn.Column: switch (version) { case ExcelVersion.Xls: return(ColumnMaxXls); case ExcelVersion.Xlsx: return(ColumnMaxXlsx); } break; } throw new InvalidEnumArgumentException("version", (int)version, version.GetType()); }