public HSSFWorkbook Export <T>(string ExportTableName, List <T> list)
{
HSSFWorkbook book = new HSSFWorkbook();
ISheet sheet = book.CreateSheet(ExportTableName);
IRow row = sheet.CreateRow(0);
HelpDAl helpDal = new HelpDAl();
var listViewDisplayName = helpDal.GetDisplayName(list.FirstOrDefault()); //得到表头信息
//设置表格样式
ICellStyle cellStyle = book.CreateCellStyle();
cellStyle.BorderBottom = BorderStyle.Thin;
cellStyle.BorderLeft = BorderStyle.Thin;
cellStyle.BorderTop = BorderStyle.Thin;
cellStyle.BorderRight = BorderStyle.Thin;
cellStyle.VerticalAlignment = VerticalAlignment.Center;
cellStyle.Alignment = HorizontalAlignment.Center;
//设置表头
for (int i = 0; i < listViewDisplayName.Count; i++)
{
row.CreateCell(i).SetCellValue(listViewDisplayName[i]);
}
//数据填充
for (int i = 0; i < list.Count; i++)
{
IRow rowtemp = sheet.CreateRow(i + 1);
var result = helpDal.GetValue(list[i]);
for (int j = 0; j < result.Count; j++)
{
rowtemp.CreateCell(j).SetCellValue(result[j]);
}
}
return(book);
}
public ExportServer(HelpDAl helpDAl)
{
_helpDAl = helpDAl;
}
