alibaba/easyexcel

导出文件慢

Open

#3.847 aberto em 21 de jun. de 2024

Ver no GitHub
 (1 comment) (0 reactions) (0 assignees)Java (7.599 forks)batch import
help wanted

Métricas do repositório

Stars
 (33.728 stars)
Métricas de merge de PR
 (Nenhuma PRs mesclada em 30d)

Description

使用 ExcelWriter 生产文件到服务端,然后通过地址前端下载文件,要等很久文件才能正常写入完成,才能正常下载。

大致代码 public R exportFullCountryPartNum() { ExcelWriter excelWriter = null; String fileName = Constants.FullCountryPartNum + System.currentTimeMillis() + ExcelTypeEnum.XLSX.getValue(); String filePath = Constants.PROJECTPROFILE + "/" + fileName; FileUtil.makeDir(filePath); try { FileCommonUtils.validaFile(filePath); excelWriter = EasyExcel.write(filePath, ExportCountryPartNumVO.class) .build(); WriteSheet writeSheet = EasyExcel.writerSheet("sheet1").build();

        for (int i = 0; i < partNumList.size(); i++) {
            excelWriter.write(pictureList, writeSheet);
        }
    } catch (Exception e) {
        return R.error("Export failed, please re export or contact the administrator!");
    } finally {
        excelWriter.close();
    }
    return R.data(fileName);
}

Guia do colaborador