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++;
}
}