BestHub
Sign in
Tag

EasyExcel

2 views collected around this technical thread.

Code Ape Tech Column
Code Ape Tech Column
Apr 3, 2025 · Backend Development

Implementing a FIFO Export Queue for Large Data Exports in a Spring Backend

The article describes a backend solution that uses a fixed‑size FIFO queue to throttle concurrent MySQL export operations, provides Java implementations of the ExportQueue, an abstract EasyExcel‑based exporter, a concrete ExportImpl service, and a test controller, and discusses remaining challenges and alternative approaches.

EasyExcelExportJava
0 likes · 10 min read
Implementing a FIFO Export Queue for Large Data Exports in a Spring Backend
Top Architect
Top Architect
Mar 24, 2025 · Backend Development

Encapsulating EasyExcel for Simplified Import/Export in Spring Boot Applications

This article demonstrates how to wrap EasyExcel in a SpringBoot‑MyBatis‑Plus project, providing clear steps, code examples, and solutions to common issues such as date conversion and POI version compatibility, enabling developers to import and export Excel data with minimal effort.

Backend DevelopmentEasyExcelExcel Import Export
0 likes · 18 min read
Encapsulating EasyExcel for Simplified Import/Export in Spring Boot Applications
Code Ape Tech Column
Code Ape Tech Column
Mar 24, 2025 · Backend Development

Optimizing Large-Scale Excel Import/Export in Java with EasyExcel, Generics, and Thread Pools

This article explains how to efficiently handle massive Excel import and export tasks in Java by using EasyExcel, Java 8 functional programming, reflection, generics, thread‑pool batching, and custom ReadListener implementations, while also providing Maven dependencies and reusable export utilities.

Backend DevelopmentEasyExcelExcel import
0 likes · 10 min read
Optimizing Large-Scale Excel Import/Export in Java with EasyExcel, Generics, and Thread Pools
Top Architect
Top Architect
Feb 10, 2025 · Backend Development

Encapsulating EasyExcel in Spring Boot for Simplified Import and Export

This article demonstrates how to wrap EasyExcel within a Spring Boot + MyBatis‑Plus project, providing step‑by‑step guidance on environment preparation, component design, usage examples, full source code, and solutions to common issues such as template export, date conversion, and POI version compatibility.

BackendEasyExcelExcelImportExport
0 likes · 17 min read
Encapsulating EasyExcel in Spring Boot for Simplified Import and Export
Java Tech Enthusiast
Java Tech Enthusiast
Feb 5, 2025 · Backend Development

Optimizing Large-Scale Excel Import/Export in Java with EasyExcel and Thread Pools

By combining EasyExcel’s low‑memory parsing with Java 8 functional style, reflection‑based generic annotations, a thread‑pool‑driven batch listener, and flexible export utilities that support dynamic headers and map‑based rows, Java back‑ends can safely import and export millions of Excel rows without OOM errors.

Data ProcessingEasyExcelExcel import
0 likes · 13 min read
Optimizing Large-Scale Excel Import/Export in Java with EasyExcel and Thread Pools
Architect's Guide
Architect's Guide
Jan 3, 2025 · Big Data

Efficient Import and Export of Millions of Records Using POI and EasyExcel in Java

This article explains how to handle massive Excel‑DB import/export tasks in Java by comparing POI workbook types, selecting the right implementation, and leveraging EasyExcel with batch queries, sheet splitting, and JDBC batch inserts to process over three million rows efficiently.

Big DataEasyExcelExcel
0 likes · 24 min read
Efficient Import and Export of Millions of Records Using POI and EasyExcel in Java
Architecture Digest
Architecture Digest
Dec 24, 2024 · Backend Development

FastExcel: The Successor to EasyExcel – Features, Migration Guide, and Code Samples

FastExcel, the newly renamed successor to EasyExcel, offers high‑performance Excel read/write, full compatibility, new features like row‑specific reading and PDF conversion, and provides detailed migration instructions with Maven/Gradle dependencies and code examples for Java developers.

EasyExcelExcelFastExcel
0 likes · 9 min read
FastExcel: The Successor to EasyExcel – Features, Migration Guide, and Code Samples
macrozheng
macrozheng
Dec 13, 2024 · Backend Development

How to Implement a FIFO Export Queue in Spring Boot to Prevent Performance Bottlenecks

To avoid performance degradation caused by simultaneous large‑scale data exports, this guide demonstrates building a fixed‑size FIFO export queue in Spring Boot, integrating EasyExcel for million‑row exports, handling asynchronous processing, and providing sample code for the queue, export service, and controller.

BackendEasyExcelExport Queue
0 likes · 12 min read
How to Implement a FIFO Export Queue in Spring Boot to Prevent Performance Bottlenecks
Java Tech Enthusiast
Java Tech Enthusiast
Dec 10, 2024 · Backend Development

Implementing a FIFO Export Queue in Spring Boot for Large Data Exports

The article demonstrates how to implement a bounded FIFO export queue in a Spring Boot application, using synchronized wait/notify methods to limit concurrent large‑data exports to ten threads, integrating with an abstract EasyExcel exporter and a controller that spawns export tasks, while noting future enhancements such as persistent storage and Redis‑based queues.

Backend DevelopmentEasyExcelExport Queue
0 likes · 11 min read
Implementing a FIFO Export Queue in Spring Boot for Large Data Exports
Architecture Digest
Architecture Digest
Dec 6, 2024 · Backend Development

EasyExcel Wrapper for Simplified Import and Export in Spring Boot Backend

This article demonstrates how to encapsulate Alibaba's EasyExcel library within a Spring Boot backend, providing step‑by‑step environment setup, entity annotations, service interfaces, implementation details, usage examples, and solutions to common issues such as date conversion and template‑based export limitations.

BackendEasyExcelExcelImportExport
0 likes · 13 min read
EasyExcel Wrapper for Simplified Import and Export in Spring Boot Backend
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Dec 1, 2024 · Backend Development

Optimizing Million-Row Excel Export with EasyExcel: Design, Implementation, and Performance Tuning

This article presents a comprehensive guide to efficiently exporting millions of rows to Excel using EasyExcel, covering performance bottlenecks, resource consumption, asynchronous processing, thread‑pool design, batch querying, streaming writes, and practical code examples to achieve fast, memory‑friendly report generation.

EasyExcelExcel ExportJava
0 likes · 35 min read
Optimizing Million-Row Excel Export with EasyExcel: Design, Implementation, and Performance Tuning
Top Architect
Top Architect
Nov 19, 2024 · Backend Development

Wrapping EasyExcel for Simplified Import and Export in Spring Boot Applications

This article demonstrates how to encapsulate EasyExcel within a Spring Boot + MyBatis‑Plus project, providing step‑by‑step usage, complete source code, and solutions to common issues such as date formatting, POI version compatibility, and template‑based export limitations.

BackendEasyExcelExcelExport
0 likes · 19 min read
Wrapping EasyExcel for Simplified Import and Export in Spring Boot Applications
Code Ape Tech Column
Code Ape Tech Column
Nov 19, 2024 · Backend Development

Encapsulating EasyExcel for Simplified Import/Export in Spring Boot Applications

This article demonstrates how to wrap the EasyExcel library in a Spring Boot + MyBatis‑Plus project, providing a unified component that simplifies Excel import and export through concise annotations, reusable service methods, and customizable converters while addressing common pitfalls such as date handling and template support.

BackendEasyExcelExcelImportExport
0 likes · 15 min read
Encapsulating EasyExcel for Simplified Import/Export in Spring Boot Applications
IT Services Circle
IT Services Circle
Nov 11, 2024 · Backend Development

EasyExcel Enters Maintenance Mode and Launches New EasyExcel-Plus Project

The EasyExcel Java Excel library, known for its low memory usage and fast processing, has entered maintenance mode while its author announced a new project, EasyExcel-Plus, promising enhanced performance, expanded data format support, and continued open‑source development.

BackendData ProcessingEasyExcel
0 likes · 3 min read
EasyExcel Enters Maintenance Mode and Launches New EasyExcel-Plus Project
Architecture Digest
Architecture Digest
Nov 8, 2024 · Backend Development

The Evolution of EasyExcel: From Alibaba’s Internal Tool to the Upcoming EasyExcel‑Plus

This article chronicles the birth, technical innovations, open‑source journey, and community impact of Alibaba’s EasyExcel library, explains its memory‑optimized streaming design with a concise code example, and announces the forthcoming EasyExcel‑Plus project along with a free book giveaway.

EasyExcelExcelJava
0 likes · 7 min read
The Evolution of EasyExcel: From Alibaba’s Internal Tool to the Upcoming EasyExcel‑Plus
Top Architect
Top Architect
Nov 2, 2024 · Backend Development

Optimizing Excel Export with EasyExcel: Performance Improvements and Merged‑Cell Strategies

This article demonstrates how to boost performance when exporting large datasets to Excel using EasyExcel, covering single‑batch, paginated, and concurrent writes, and explains multiple approaches—including annotations and custom WriteHandlers—to efficiently create merged cells in the generated spreadsheets.

Cell MergingEasyExcelExcel Export
0 likes · 18 min read
Optimizing Excel Export with EasyExcel: Performance Improvements and Merged‑Cell Strategies
Java Architect Essentials
Java Architect Essentials
Oct 30, 2024 · Backend Development

Optimizing Excel Export with EasyExcel: Performance, Pagination, Concurrency, and Cell‑Merging Strategies

This article demonstrates how to use EasyExcel to efficiently export large volumes of data to Excel by improving performance through pagination, concurrent queries, and custom cell‑merging strategies, including built‑in annotations and WriteHandler implementations, while providing complete Java code examples.

Cell MergingEasyExcelExcel Export
0 likes · 16 min read
Optimizing Excel Export with EasyExcel: Performance, Pagination, Concurrency, and Cell‑Merging Strategies
Architecture Digest
Architecture Digest
Sep 29, 2024 · Backend Development

Implementing a Fixed‑Size FIFO Export Queue in a Java Backend with Spring and EasyExcel

This article explains how to design and implement a fixed-size FIFO export queue in a Java backend using Spring components and EasyExcel, covering business requirements, class definitions, code examples, testing results, and considerations for further enhancements such as Redis queues and high‑concurrency scenarios.

BackendEasyExcelExport
0 likes · 12 min read
Implementing a Fixed‑Size FIFO Export Queue in a Java Backend with Spring and EasyExcel
IT Architects Alliance
IT Architects Alliance
Sep 24, 2024 · Backend Development

Implementing a FIFO Export Queue for Large Data Exports in Java

The article describes a Java‑based FIFO export queue that limits concurrent MySQL export operations, outlines the related classes (ExportQueue, AbstractExport, ExportImpl, and a test controller), provides full source code, and presents test results showing how the queue manages up to ten simultaneous export requests.

EasyExcelExportQueueFIFO
0 likes · 11 min read
Implementing a FIFO Export Queue for Large Data Exports in Java