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