使用POI导出Excel文件
private XSSFWorkbook writeExcel(List<SupplyKcPlan> list) {
if(CollectionUtils.isEmpty(list)){
return new XSSFWorkbook();
}
XSSFWorkbook wb = new XSSFWorkbook();
Map<String, CellStyle> styles = createStyles(wb);
XSSFSheet sheet = wb.createSheet("sheet1");
//定义列标题 14列
String[] titles = {
"日期", "单位名称", "专业类型", "序号", "考察时间","", "行程名称", "地址项目概况", "项目名称", "项目甲方", "承包内容", "施工阶段", "联系人", "电话"};
XSSFRow rowTitle = sheet.createRow(0);
XSSFCell titleCell = rowTitle.createCell(0);
titleCell.setCellValue("考察行程");
titleCell.setCellStyle(styles.get("title"));
rowTitle.setHeight((short) 800);
//合并第一行的列
CellRangeAddress titleRegion = new CellRangeAddress(0, 0, 0, titles.length - 1);
sheet.addMergedRegion(titleRegion);
CellRangeAddress headerRegion = new CellRangeAddress(1, 1,4,5);
sheet.addMergedRegion(headerRegion);
XSSFRow row = sheet.createRow(1);
// 将列名写入
for (int i = 0; i < titles.length; i++) {
// 给列写入数据,创建单元格,写入数据
XSSFCell headerCell = row.createCell(i);
headerCell.setCellValue(titles[i]</