alibaba / easyexcel

快速、简洁、解决大文件内存溢出的java处理Excel工具
https://easyexcel.opensource.alibaba.com
Apache License 2.0
31.64k stars 7.46k forks source link

写入sheet的顺序id无效 #2687

Open baili123 opened 1 year ago

baili123 commented 1 year ago

写入excel时,使用com.alibaba.excel.EasyExcelFactory#writerSheet(java.lang.Integer, java.lang.String)设置的sheetNo没用。 例如下面这段代码:

 WriteSheet writeSheet1 = EasyExcel.writerSheet(0, "aaa"  ).head(WithdrawSummaryExcelData.class).build();
 WriteSheet writeSheet2 = EasyExcel.writerSheet(1, "bbb"  ).head(WithdrawDetailExcelData.class).build();
...
excelWriter.write( bbb,writeSheet2);
excelWriter.write( aaa,writeSheet1);           

期望是writeSheet1排在最左,但实际上是writeSheet2排在最左。 也就是说sheet的顺序取决于写入的顺序,而非设置的sheetNo。

Kcyfrank commented 7 months ago

啥时候修复啊 @zhuangjiaju

Kcyfrank commented 7 months ago

WriteSheet writeSheet1 = EasyExcel.writerSheet(0, "aaa" ).head(WithdrawSummaryExcelData.class).build(); WriteSheet writeSheet2 = EasyExcel.writerSheet(1, "bbb" ).head(WithdrawDetailExcelData.class).build(); ... // 手动声明触发sheetADD,勉强能用。。 excelWriter.writeContext().currentSheet(writeSheet1, WriteTypeEnum.ADD); ... excelWriter.write( bbb,writeSheet2); excelWriter.write( aaa,writeSheet1);