alibaba/easyexcel

请问大数据导出如何控制写磁盘的时机和占用内存的大小

Open

#3578 aperta il 28 nov 2023

Vedi su GitHub
 (1 commento) (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

最近做项目,需要帮助用户导出审批记录到excel,数据量大概100万左右,用的组件是easyexcel3.3.2,现在写的代码是:

try (ExcelWriter excelWriter = EasyExcel.write(fileName, FlowExcel.class).build()) {
    WriteSheet writeSheet = EasyExcel.writerSheet("sheet1").build();
    // 迭代数据库数据,
    flowService.iterateAllFlow(flows -> {
        // 转换数据
        List<FlowExcel> flowExcels = transferExcel(flows);
        // 写excel
        excelWriter.write(flowExcels, writeSheet);
    });
}

导出能正常工作,如果希望能控制写磁盘的时机和占用内存的大小,有相应的接口吗?要如何写?(看了文档,没有找到答案)

Guida contributor