一个excel中，填充多个不同的list时，个别表格第一行和第二行中间自动出现多行空白行，返回的list里没有这种数据 · Issue #3712 · alibaba/easyexcel · GitHub |
您所在的位置：网站首页 › excel第一第二第三填充不了 › 一个excel中，填充多个不同的list时，个别表格第一行和第二行中间自动出现多行空白行，返回的list里没有这种数据 · Issue #3712 · alibaba/easyexcel · GitHub |
一个excel中，填充多个不同的list时，个别表格第一行和第二行中间自动出现多行空白行，返回的list里没有这种数据 · Issue #3712 · alibaba/easyexcel · GitHub
|
String templateFileName = "fill" + File.separator + "composite33.xlsx"; String fileName = uploadPath + File.separator + "compositeFill" + ".xlsx"; // 方案1 try (InputStream res = this.getClass().getClassLoader().getResourceAsStream(templateFileName); ExcelWriter excelWriter = EasyExcel.write(fileName).withTemplate(res).build(); ) { WriteSheet writeSheet = EasyExcel.writerSheet().build(); Date thisDate = new Date(); Date yesterdayDate = DateUtil.yesterday(); String yesterday = DateUtil.format(yesterdayDate, "yyyy-MM-dd"); Map map = new HashMap(); map.put("date", thisDate); map.put("yesterday", yesterday); map.put("thisDate", DateUtil.format(thisDate, "yyyy-MM-dd")); map.put("week", String.valueOf(DateUtil.weekOfYear(yesterdayDate))); map.put("month", String.valueOf(DateUtil.month(yesterdayDate)+1)); map.put("year", String.valueOf(DateUtil.year(yesterdayDate))); map.put("lastYear", String.valueOf(DateUtil.year(yesterdayDate) -1)); String quarterStr = "Q"+DateUtil.quarter(yesterdayDate); map.put("quarter", quarterStr); map.put("title", "*每周按日历周统计；今年的数据计算到天，去年同期计算到月，同比增长率只在月末才显示值"); excelWriter.fill(map, writeSheet); FillConfig fillConfig = FillConfig.builder().forceNewRow(Boolean.TRUE).build(); // 如果有多个list 模板上必须有{前缀.} 这里的前缀就是 data1，然后多个list必须用 FillWrapper包裹 excelWriter.fill(new FillWrapper("orgReport", orgReport), fillConfig, writeSheet); excelWriter.fill(new FillWrapper("blReport", blReport), fillConfig, writeSheet); excelWriter.fill(new FillWrapper("areaReport", areaReport), fillConfig, writeSheet); excelWriter.fill(new FillWrapper("plReport", plReport), fillConfig, writeSheet); excelWriter.fill(new FillWrapper("orgSaleReport", orgSaleReport), fillConfig, writeSheet); excelWriter.fill(new FillWrapper("blSaleReport", blSaleReport), fillConfig, writeSheet); excelWriter.fill(new FillWrapper("areaSaleReport", areaSaleReport), fillConfig, writeSheet); excelWriter.fill(new FillWrapper("plSaleReport", plSaleReport), fillConfig, writeSheet); excelWriter.finish(); } catch (Exception ex) { log.error("填充附件Excel失败" + JSON.toJSONString(ex)); throw new MktSellException("填充附件Excel失败!"); }
|
【本文地址】
今日新闻 |
推荐新闻 |