alibaba/easyexcel

数据替换行在中间,尾行数据文字导出数据丢失,求帮助

Open

#3955 aperta il 26 ago 2024

Vedi su GitHub
 (0 commenti) (0 reazioni) (0 assegnatari)Java (7599 fork)batch import
help wanted

Metriche repository

Star
 (33.728 star)
Metriche merge PR
 (Nessuna PR mergiata in 30 g)

Descrizione

建议先去看文档

快速开始常见问题

异常代码

  public static void exportExcelByTemplate(String templatePath, List<? extends DataEntity> dataList
            , HttpServletResponse response, String exportName, Map<String, Object> headData) throws Exception {
        response.setHeader("Access-Control-Expose-Headers", "Content-Disposition");
        ExcelWriter excelWriter = EasyExcel
                .write(getOutputStream(exportName, response))
                .withTemplate(templatePath)
                .build();
        WriteSheet writeSheet = EasyExcel.writerSheet().build();
        FillConfig fillConfig = FillConfig.builder().forceNewRow(Boolean.TRUE).build();
        excelWriter.fill(headData,fillConfig, writeSheet);
        excelWriter.fill(dataList,fillConfig, writeSheet);
        excelWriter.finish();
    }

问题描述

版本3.3.2 在使用固定模板导出文件时,索引 0 1 行为 head, 2 为数据替换行,3 为尾行文字描述 遍历数据,采取新增行方式(forceNewRow(Boolean.TRUE)),导出后,索引 3 尾行数据丢失,求告知 是被覆盖还是其他操作原因,求解决方法 Uploading 微信图片_20240826182713.png…

Guida contributor