EasyExcel根据模板动态导出一个Excel多个sheet

原创

已于 2024-05-13 16:35:58 修改 · 1.4k 阅读

7 ·

CC 4.0 BY-SA版权

文章标签：

#excel #java #windows

于 2024-05-13 16:34:56 首次发布

模板

在这里插入图片描述
模板放在项目中的位置：template/excel/certificateTemplate.xlsx

代码

  @Test
    public void test06() throws IOException {
        File rootPath = new File(ResourceUtils.getURL("classpath:").getPath());
        File templatePath = new File(rootPath.getAbsolutePath(), "template/excel/certificateTemplate.xlsx");
        String outsFileName = "预付款凭证-" + System.currentTimeMillis() + ".xlsx";

        String modelFileName = "tempFile.xlsx";
        File outModelFile = new File(modelFileName);

        File outsFile = new File(rootPath + "/" + outsFileName);

        String name = "张三1,张三2";
        List<String> taskNoList = Arrays.asList(name.split(","));

        EasyExcelUtil.createModel(taskNoList, outModelFile, templatePath);
       ExcelWriter excelWriter = EasyExcel.write(outsFile).withTemplate(outModelFile).build();
       // ExcelWriter excelWriter = EasyExcelUtil.setStyle(outModelFile, outsFile);
        for (String taskNo : taskNoList) {
            WriteSheet writeSheet = EasyExcel.writerSheet(taskNo).build();
            FillData stocktakeTaskVo = getInfo(taskNo);

            if (stocktakeTaskVo != null) {
                Map<String, Object> map = MapUtils.newHashMap();
                map.put("nowDate", Dat