easyexcel icon indicating copy to clipboard operation
easyexcel copied to clipboard

写入sheet的顺序id无效

Open baili123 opened this issue 3 years ago • 3 comments

写入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。

baili123 avatar Aug 30 '22 09:08 baili123

啥时候修复啊 @zhuangjiaju

Kcyfrank avatar Jan 02 '24 08:01 Kcyfrank

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);

Kcyfrank avatar Jan 02 '24 08:01 Kcyfrank