alibaba/easyexcel

导出文件慢

Open

#3.847 geöffnet am 21. Juni 2024

Auf GitHub ansehen
 (1 Kommentar) (0 Reaktionen) (0 zugewiesene Personen)Java (7.599 Forks)batch import
help wanted

Repository-Metriken

Stars
 (33.728 Stars)
PR-Merge-Metriken
 (Keine gemergten PRs in 30 T)

Beschreibung

使用 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);
}

Contributor Guide