[alibaba/easyexcel]多sheet写入时出现所有数据写不进去

2024-05-24 860 views
4

异常代码

   try (OutputStream outputStream = response.getOutputStream()) {
            ExcelWriter excelWriter = EasyExcel.write(outputStream).build();
            for (ExportSheetDetail<M> sheetDetail : sheetDetails) {
                sheetDetail.validatedAndInit();
                WriteSheet writeSheet = EasyExcel
                    .writerSheet(sheetDetail.getSheetNo(), sheetDetail.getSheetName()).build();
                excelWriter.write(sheetDetail.getData(), writeSheet);
            }
            excelWriter.finish();
            outputStream.flush();
        } catch (Exception e) {
            log.error(e.getMessage());
        }

异常提示 没有抛出任何异常 建议描述

屏幕快照 2019-11-30 上午11 57 05

回答

6

出现如下提示: 2019-11-30 11:55:18.979 ERROR 3039 --- [nio-8080-exec-1] c.component.easyexcel.EasyExcelExecutor : Attempting to write a row[0] in the range [0,49499] that is already written to disk.

6

升级到 2.1.3试试看?或者 demo 试试 在写入哪个sheet出的问题

7

是否已经解决该问题,如果未解决,请重新打开问题。