阿里的EasyExcel使用模板添加，不能修改sheet名称

Question

main方法

        File outExcel = new File("./outExcel.xlsx");
        outExcel.createNewFile();
        File template = new File(App.class.getClassLoader().getResource("workOrderTemplate.xlsx").getFile());
        ExcelWriter writerBook = EasyExcel.write(outExcel).withTemplate(template).build();
        WriteSheet writeSheet = EasyExcel.writerSheet().head(Bean.class).build();
        Bean test = new Bean();
        test.setDate(Calendar.getInstance().getTime());
        test.setId("236");
        test.setName("fwwfs");
                writeSheet.setSheetName("test01");
        writerBook.fill(test, writeSheet);
        writerBook.finish();

结果显示：



永远都是Sheet1，模板的sheet名换了，结果还是没变

Answer 1

可以修改，注册一个Sheet的拦截器
.registerWriteHandler(new CustomSheetWriteHandler())