esayExcel模板填充（混合填充）

1. 引入easyExcel依赖

<!--easyexcel-->
<dependency>
  <groupId>com.alibaba</groupId>
  <artifactId>easyexcel</artifactId>
  <version>3.1.1</version>
</dependency>

但是由于easyExcel自带依赖于3.17的poi，所以如果项目其它地方引入了其它版本的poi，就会导致easyExcel导出失败等一系列问题，主要原因是因为poi版本冲突导致的，这里我提供的解决办法是，引入easyExcel的时候，排除easyExcel中自带的poi依赖。

<!--集成EasyExcel -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>easyexcel</artifactId>
            <version>2.2.6</version>
            <exclusions>
                <exclusion>
                    <groupId>javax.servlet</groupId>
                    <artifactId>servlet-api</artifactId>
                </exclusion>
                <exclusion>
                    <groupId>org.apache.poi</groupId>
                    <artifactId>poi</artifactId>
                </exclusion>
                <exclusion>
                    <groupId>org.apache.poi</groupId>
                    <artifactId>poi-ooxml</artifactId>
                </exclusion>
                <exclusion>
                    <groupId>org.apache.poi</groupId>
                    <artifactId>poi-ooxml-schemas</artifactId>
                </exclusion>
            </exclusions>
        </dependency>

这也是我再网上查阅的资料，引这个就不需要开头的依赖了

2. 具体实现

 @Override
    public void export(HttpServletResponse response) throws IOException {
        //查询30天的汇总数据
        LocalDateTime endTime = LocalDateTime.now();
        LocalDateTime startTime = endTime.minusDays(30).toLocalDate().atStartOfDay();
        BusinessDataVO businessDataVO = workSpaceServicel.businessData(startTime, endTime);
        log.info("businessDataVO：{}", businessDataVO.toString());
        //查询每一天的明细数据
        List<BusinessDataVO> dayVoList = new ArrayList<>();
        while (startTime.isBefore(endTime)) {
            LocalDateTime end = startTime.plusDays(1).minusSeconds(1);
            BusinessDataVO dayVo = workSpaceServicel.businessData(startTime, end);
            log.info("startTime:{}, dayVo：{}", startTime, dayVo);
            dayVo.setDate(String.valueOf(LocalDate.from(startTime)));
            dayVoList.add(dayVo);
            startTime = startTime.plusDays(1);
        }
        //输入流
        InputStream inputStream = this.getClass().getClassLoader().getResourceAsStream("templates/运营数据报表模板.xlsx");
        ServletOutputStream outputStream = response.getOutputStream();

        //设置输出流和模板信息
        ExcelWriter excelWriter = EasyExcel.write(outputStream).withTemplate(inputStream).build();
        WriteSheet writeSheet = EasyExcel.writerSheet().build();

        //开启自动换行，自动换行表示每次写入一条list数据是都会重新生成一行空行,此选项默认是关闭的,需要提前设置为true
        FillConfig fillConfig = FillConfig.builder().forceNewRow(Boolean.TRUE).build();
        //列表
        excelWriter.fill(dayVoList, fillConfig, writeSheet);

        Map<String, Object> dateAndTotal = new HashMap<>();
        dateAndTotal.put("aturnover", businessDataVO.getTurnover());
        dateAndTotal.put("aorderCompletionRate", businessDataVO.getOrderCompletionRate());
        dateAndTotal.put("anewUsers", businessDataVO.getNewUsers());
        dateAndTotal.put("avalidOrderCount", businessDataVO.getValidOrderCount());
        dateAndTotal.put("aunitPrice", businessDataVO.getUnitPrice());
        //单个
        excelWriter.fill(dateAndTotal, writeSheet);

        //关流
        excelWriter.finish();
        inputStream.close();
        outputStream.close();

    }
}

3. 创建实体类

/**
 * 数据概览
 */
@Data
@Builder
@NoArgsConstructor
@AllArgsConstructor
public class BusinessDataVO implements Serializable {

    private Double turnover;//营业额

    private Integer validOrderCount;//有效订单数

    private Double orderCompletionRate;//订单完成率

    private Double unitPrice;//平均客单价

    private Integer newUsers;//新增用户数

    private String date;//时间
}

4. 模板样式

模板填充数据需要{}，如果是list，需要{.}