alibaba/easyexcel

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

Open

#3,578 opened on Nov 28, 2023

View on GitHub
 (1 comment) (0 reactions) (0 assignees)Java (7,599 forks)batch import
help wanted

Repository metrics

Stars
 (33,728 stars)
PR merge metrics
 (No merged PRs in 30d)

Description

最近做项目，需要帮助用户导出审批记录到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);
    });
}

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

Contributor guide

Research direction
Investigate the EasyExcel source code to find the WriteManager and MemoryHandler classes. Understand how they control write timing and memory usage. Look for APIs that allow configuring buffer size or flush thresholds.
Tech stack
java
Domain
backend
Issue type
Research
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
None
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
70