alibaba/easyexcel

导出--合并单元格很慢，超过3分钟

Open

#3,979 opened on Sep 6, 2024

View on GitHub
 (3 comments) (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

问题描述：导出--合并单元格很慢，超过3分钟，目前数据大概在6千条，使用的版本是2.2.8，使用的合并策略是自定义的，因为1到5列合并，8到10列合并，不是连续的合并。

所以想问下，有什么好的方法吗？能让导出时间控制在10s内，因为我见大家提的问题，没找到合适的解决方案。

Contributor guide

Research direction
Investigate the performance bottleneck in merge cell export. Consider using EasyExcel's batch write strategy to reduce memory overhead and merge cell operations. Check if custom merge strategy can be optimized by merging in a single pass or using a cache. Also consider exporting in smaller chunks or upgrading to a newer version.
Tech stack
java
Domain
backend
Issue type
Performance
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
Half day
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.
Mostly clear
Prerequisites
JavaEasyExcel
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
50