easyexcel 模板导出文件 #

    @Override
    public String export(String start, String end) throws FileNotFoundException {

        String filename = UUID.randomUUID() + "_" + "sheet" + ".xlsx";
        String downloadPath = RuoYiConfig.getDownloadPath() + filename;
//        String templateFileName = ResourceUtils.getURL("classpath:xlsx/template.xlsx").getPath();
        InputStream templateFileName = this.getClass().getClassLoader().getResourceAsStream("xlsx/template.xlsx");
        ExcelWriter excelWriter = EasyExcel.write(downloadPath).withTemplate(templateFileName).build();
        WriteSheet writeSheet = EasyExcel.writerSheet().build();
        FillConfig fillConfig = FillConfig.builder().direction(WriteDirectionEnum.HORIZONTAL).build();

        // 生成日期标题
        List<HashMap<String, String>> excelTitle = this.genExcelTitle(end);
        excelWriter.fill(new FillWrapper("t", excelTitle), fillConfig, writeSheet);

        // 查询数据
        List<Map<String, Object>> maps = this.listBetweenMonth(start, end).getData();
        FillConfig fillConfig2 = FillConfig.builder().autoStyle(true).build();
        excelWriter.fill(new FillWrapper("d", maps), fillConfig2, writeSheet);
        excelWriter.finish();
        return filename;
    }