public HSSFWorkbook CreateWorkbookTemplate() { HSSFWorkbook workbook = new HSSFWorkbook(); HSSFSheet sheet = (HSSFSheet)workbook.CreateSheet(fMetaData.Table.TableDesc); HSSFRow dataRow = (HSSFRow)sheet.CreateRow(0); int index = 0; foreach (Tk5FieldInfoEx fieldInfo in fMetaData.Table.TableList) { int colWith = ExcelUtil.GetColWidth(fieldInfo); sheet.SetColumnWidth(index, colWith << 8); ICellStyle styleContent = BorderAndFontSetting(workbook, fieldInfo, Model.Content); HSSFDataValidation dataValidate = ExcelUtil.CreateDataValidation(index, fieldInfo, styleContent, workbook); sheet.SetDefaultColumnStyle(index, styleContent); if (dataValidate != null) { ((HSSFSheet)sheet).AddValidationData(dataValidate); } ICell cell = dataRow.CreateCell(index); ICellStyle styleHeader = BorderAndFontSetting(workbook, fieldInfo, Model.Header); cell.SetCellValue(fieldInfo.DisplayName); cell.CellStyle = styleHeader; index++; } return(workbook); }
// 表格头部设置 private void HeaderSetting(IWorkbook workbook, ISheet sheet) { IRow dataRow = sheet.CreateRow(0); int index = 0; foreach (Tk5FieldInfoEx fieldInfo in fMetaData.Table.TableList) { ICell cell = dataRow.CreateCell(index); ICellStyle styleHeader = BorderAndFontSetting(workbook, fieldInfo, Model.Header); cell.SetCellValue(fieldInfo.DisplayName); cell.CellStyle = styleHeader; int colWith = ExcelUtil.GetColWidth(fieldInfo); sheet.SetColumnWidth(index, colWith << 8); index++; } }