BestHub
Sign in
Tagged articles
92 articles
Page 1 of 1
Java Tech Enthusiast
Java Tech Enthusiast
May 5, 2026 · Backend Development

Quick Start Guide to Using EasyExcel with Spring Boot 3 (Verified)

This tutorial walks through building a Spring Boot 3 project that integrates Alibaba's EasyExcel for Excel export and import, covering project structure, Maven dependencies, entity mapping, listener implementation, service and controller code, testing endpoints, and key Spring Boot 3 considerations such as Jakarta packages, JDK 17+, response header handling, memory management, and production‑grade best practices.

Excel Importbackend-developmenteasyexcel
0 likes · 14 min read
Quick Start Guide to Using EasyExcel with Spring Boot 3 (Verified)
Top Architect
Top Architect
Mar 27, 2026 · Backend Development

Why FastExcel Is the Next‑Gen High‑Performance Java Excel Library

FastExcel, created after Alibaba stopped updating EasyExcel, offers seamless EasyExcel compatibility, dramatically lower memory usage, and high‑speed read/write for massive Excel files, while being free under the MIT license and backed by a thriving open‑source community that also fuels the AI‑driven database tool Chat2DB.

Chat2DBExcelFastExcel
0 likes · 19 min read
Why FastExcel Is the Next‑Gen High‑Performance Java Excel Library
Architect's Guide
Architect's Guide
Mar 17, 2026 · Backend Development

Why Lombok’s Getter/Setter Naming Breaks MyBatis Inserts and How to Fix It

This article explains how Lombok’s generation of getter/setter methods for fields whose second character is uppercase can cause MyBatis to map properties incorrectly, leading to null values, and also examines why the @Accessor(chain=true) annotation breaks EasyExcel’s reflection, offering concrete solutions for each case.

GetterSetterLombokMyBatis
0 likes · 9 min read
Why Lombok’s Getter/Setter Naming Breaks MyBatis Inserts and How to Fix It
Architect's Guide
Architect's Guide
Jan 1, 2026 · Backend Development

How to Efficiently Import and Export Millions of Records with POI and EasyExcel

This article explains how to handle massive Excel import/export tasks in Java by comparing POI workbook implementations, selecting the appropriate class based on data size, and using EasyExcel with batch processing, JDBC transactions, and pagination to achieve fast, low‑memory operations for hundreds of millions of rows.

Data ExportPOIdata import
0 likes · 21 min read
How to Efficiently Import and Export Millions of Records with POI and EasyExcel
Java Companion
Java Companion
Dec 29, 2025 · Backend Development

Avoid OOM: EasyExcel Best Practices for Exporting Millions of Rows (with Ready‑to‑Use Helper)

This article explains why exporting large Excel files with EasyExcel can cause OOM, CPU blockage, and slow responses, and demonstrates a pagination‑query plus batch‑write solution with reusable helper classes, performance benchmarks, dynamic page sizing, async export, multi‑sheet and template techniques, and a concise best‑practice checklist.

Asynceasyexcelexcel-export
0 likes · 15 min read
Avoid OOM: EasyExcel Best Practices for Exporting Millions of Rows (with Ready‑to‑Use Helper)
Top Architect
Top Architect
Dec 28, 2025 · Backend Development

Why FastExcel Is the Next‑Gen High‑Performance Excel Library for Java Developers

FastExcel, a Java library born from the discontinuation of EasyExcel, offers seamless migration, MIT‑licensed open‑source code, and dramatic performance gains for processing massive Excel files, while also introducing innovative features like selective row reading and Excel‑to‑PDF conversion, and it paves the way for the AI‑driven database tool Chat2DB.

Chat2DBExcelFastExcel
0 likes · 18 min read
Why FastExcel Is the Next‑Gen High‑Performance Excel Library for Java Developers
Java Architecture Diary
Java Architecture Diary
Dec 8, 2025 · Backend Development

EasyExcel Archived? How FastExcel and Apache Fesod Provide a Modern Java Excel Solution

When Alibaba archived the popular EasyExcel library, developers faced uncertainty about future maintenance, memory usage, and JDK compatibility, prompting the emergence of FastExcel as a drop‑in replacement and the Apache‑incubated Fesod project, which together offer a high‑performance, low‑memory Java Excel processing ecosystem.

Apache FesodExcelFastExcel
0 likes · 10 min read
EasyExcel Archived? How FastExcel and Apache Fesod Provide a Modern Java Excel Solution
Senior Tony
Senior Tony
Dec 1, 2025 · Databases

How to Efficiently Import 100 Million Excel Rows into MySQL

This article explains how to import a hundred‑million‑row Excel dataset into MySQL by using CSV format, streaming parsers like EasyExcel, batch inserts, asynchronous processing, and partial‑transaction strategies to ensure feasibility, data integrity, and high performance.

Batch InsertExcelStreaming
0 likes · 5 min read
How to Efficiently Import 100 Million Excel Rows into MySQL
Architect's Guide
Architect's Guide
Oct 31, 2025 · Backend Development

Master EasyExcel: From Setup to Advanced Export Techniques in Java

Learn how to integrate EasyExcel into a Java Spring Boot project, covering dependency setup, entity definition, utility class creation, basic and advanced export features such as multi-level headers, merged cells, custom formatting, and large data streaming, plus common pitfalls and solutions.

Spring Booteasyexcelexcel-export
0 likes · 10 min read
Master EasyExcel: From Setup to Advanced Export Techniques in Java
Java Web Project
Java Web Project
Oct 28, 2025 · Backend Development

Why Lombok’s Getter/Setter Naming Breaks MyBatis (and EasyExcel) and How to Fix It

The article analyzes a Lombok @Data‑generated getter/setter naming mismatch that causes MyBatis to store a null enum field, walks through debugging, examines MyBatis’s PropertyNamer source, demonstrates the issue with test code, and then explains a similar @Accessor(chain=true) problem in EasyExcel, offering concrete workarounds for both.

GetterSetterLombokMyBatis
0 likes · 9 min read
Why Lombok’s Getter/Setter Naming Breaks MyBatis (and EasyExcel) and How to Fix It
Top Architect
Top Architect
Jul 7, 2025 · Backend Development

Simplify Excel Import/Export in Spring Boot with an EasyExcel Wrapper

This article walks through building a reusable EasyExcel wrapper for Spring Boot, covering environment setup, step‑by‑step usage, full source code, common pitfalls like date formatting and POI version conflicts, and practical solutions to ensure reliable Excel import and export.

Data ConversionExcel ImportJava backend
0 likes · 20 min read
Simplify Excel Import/Export in Spring Boot with an EasyExcel Wrapper
Lin is Dream
Lin is Dream
May 8, 2025 · Backend Development

Boost Large-Scale Excel Exports in Java with a Multi-Threaded EasyExcel Template

This article introduces a reusable Java template that leverages EasyExcel v3.3.2 to efficiently export massive backend datasets—such as orders or financial records—to Excel, supporting both multi‑threaded and synchronous modes, pagination, sheet splitting, and customizable query logic, thereby reducing repetitive code and improving performance.

easyexcelexcel-exportjava
0 likes · 11 min read
Boost Large-Scale Excel Exports in Java with a Multi-Threaded EasyExcel Template
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.

ExportQueueconcurrency
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.

Excel Import Exportbackend-developmenteasyexcel
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.

Excel ImportGenericseasyexcel
0 likes · 10 min read
Optimizing Large-Scale Excel Import/Export in Java with EasyExcel, Generics, and Thread Pools
Java Backend Technology
Java Backend Technology
Feb 14, 2025 · Backend Development

Master Efficient Excel Import/Export in Java with EasyExcel and Thread Pools

Learn how to efficiently handle large-scale Excel import and export in Java web applications using EasyExcel, leveraging Java 8 functional programming, reflection, thread pools, and custom ReadListener implementations to minimize memory usage, improve performance, and support flexible data mapping and dynamic schema handling.

Data ExportExcel ImportSpring Boot
0 likes · 14 min read
Master Efficient Excel Import/Export in Java with EasyExcel 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.

ExcelImportExporteasyexceljava
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.

Excel Importdata-processingeasyexcel
0 likes · 13 min read
Optimizing Large-Scale Excel Import/Export in Java with EasyExcel and Thread Pools
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.

BackendExport QueueFIFO
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.

Export QueueSpring Bootconcurrency
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.

ExcelImportExportSpringBooteasyexcel
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.

ThreadPooleasyexcelexcel-export
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.

ExcelExportSpringBooteasyexcel
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.

BackendExcelImportExportMyBatis
0 likes · 15 min read
Encapsulating EasyExcel for Simplified Import/Export in Spring Boot Applications
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 Mergingconcurrencyeasyexcel
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 Mergingconcurrencyeasyexcel
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.

BackendExportQueue
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.

ExportQueueFIFOconcurrency
0 likes · 11 min read
Implementing a FIFO Export Queue for Large Data Exports in Java
Architect's Tech Stack
Architect's Tech Stack
Jun 24, 2024 · Backend Development

Implementing a FIFO Export Queue for Large‑Scale Data Export in Java

This article explains how to design and implement a fixed-size FIFO export queue in Java to manage large‑scale MySQL data exports, detailing the ExportQueue class, abstract export logic with EasyExcel, a concrete ExportImpl service, and a test controller, while discussing performance considerations and future enhancements.

ExportQueueeasyexcel
0 likes · 11 min read
Implementing a FIFO Export Queue for Large‑Scale Data Export in Java
Java Captain
Java Captain
May 4, 2024 · Backend Development

Implementing a FIFO Export Queue for Large Data Exports in Java

This article explains how to design and implement a fixed‑size FIFO export queue in a Java Spring application to control concurrent MySQL data exports, detailing the related entities, code implementation with EasyExcel, a test controller, and observed results.

BackendExport Queueconcurrency
0 likes · 10 min read
Implementing a FIFO Export Queue for Large Data Exports in Java
Architecture Digest
Architecture Digest
Apr 29, 2024 · Backend Development

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

This article explains how to design and implement a fixed-size FIFO export queue in a Spring Boot backend, using synchronized methods, EasyExcel for large data exports, and a test controller to simulate concurrent export requests, while discussing performance considerations and future enhancements.

BackendExport QueueSpring Boot
0 likes · 10 min read
Implementing a FIFO Export Queue in Spring Boot for Large Data Exports
Java Architect Essentials
Java Architect Essentials
Mar 11, 2024 · Backend Development

Designing a Bounded FIFO Export Queue for Large MySQL Data Exports in Java Spring

To prevent performance degradation during large MySQL data exports, this article presents a Java Spring implementation of a bounded FIFO export queue, detailing the ExportQueue class, abstract export handling with EasyExcel, concrete service and controller code, and test results demonstrating queue limits and concurrency considerations.

ExportQueueconcurrency
0 likes · 11 min read
Designing a Bounded FIFO Export Queue for Large MySQL Data Exports in Java Spring
Selected Java Interview Questions
Selected Java Interview Questions
Mar 6, 2024 · Backend Development

Encapsulating EasyExcel for Simplified Import/Export in Spring Boot Applications

This article demonstrates how to wrap EasyExcel within a Spring Boot + MyBatis‑Plus project to provide clean, reusable import and export APIs, covering environment setup, annotation usage, controller implementation, core service design, common pitfalls, and solutions for date and template handling.

BackendCodeExampleExcelImportExport
0 likes · 19 min read
Encapsulating EasyExcel for Simplified Import/Export in Spring Boot Applications
Selected Java Interview Questions
Selected Java Interview Questions
Jan 12, 2024 · Backend Development

Efficient Excel Processing with EasyExcel in Java

This article introduces EasyExcel, a Java library that simplifies high‑performance Excel read/write operations, explains its core concepts, provides practical code examples for reading, writing, and filling Excel files, and discusses performance‑optimizing techniques and important usage considerations.

BackendDataProcessingExcel
0 likes · 16 min read
Efficient Excel Processing with EasyExcel in Java
Java Interview Crash Guide
Java Interview Crash Guide
Sep 22, 2023 · Backend Development

Why Lombok’s Getter/Setter Breaks MyBatis and EasyExcel – and How to Fix It

This article explains how Lombok’s unconventional getter/setter naming for fields with a lowercase‑first, uppercase‑second pattern causes MyBatis to map enum properties as null, and how the @Accessor(chain=true) annotation in EasyExcel triggers cglib reflection issues, then provides practical workarounds for both problems.

AccessorGetterSetterLombok
0 likes · 9 min read
Why Lombok’s Getter/Setter Breaks MyBatis and EasyExcel – and How to Fix It
Java Interview Crash Guide
Java Interview Crash Guide
Aug 10, 2023 · Big Data

How to Efficiently Import and Export Millions of Records with EasyExcel and POI

This article explains the differences between POI's HSSFWorkbook, XSSFWorkbook and SXSSFWorkbook, provides guidelines for selecting the right workbook based on data volume and Excel features, and demonstrates batch export and import of hundreds of millions of rows using EasyExcel, JDBC batch inserts, and transaction control to achieve high performance and low memory consumption.

Data ExportPOIdata import
0 likes · 22 min read
How to Efficiently Import and Export Millions of Records with EasyExcel and POI
Code Ape Tech Column
Code Ape Tech Column
Jun 28, 2023 · Backend Development

Optimizing Large-Scale Excel Import in Java: From POI to EasyExcel with Caching, Batch Inserts, and Parallel Streams

This article details a step‑by‑step optimization of a high‑volume Excel import workflow in Java, covering the migration from raw POI to EasyPOI and EasyExcel, caching database lookups, using MySQL batch inserts, and leveraging parallel streams to reduce import time from minutes to under two minutes.

Batch InsertExcelParallel Stream
0 likes · 12 min read
Optimizing Large-Scale Excel Import in Java: From POI to EasyExcel with Caching, Batch Inserts, and Parallel Streams
Java Interview Crash Guide
Java Interview Crash Guide
May 24, 2023 · Backend Development

Why Lombok’s Getter/Setter Breaks MyBatis and EasyExcel: Hidden Pitfalls Explained

This article explores how Lombok’s auto‑generated getter/setter methods can conflict with MyBatis property naming conventions and cause null values, examines the underlying reflection logic in MyBatis, and also reveals why the @Accessor(chain=true) annotation disrupts EasyExcel’s CGLIB‑based mapping, offering practical solutions.

GetterSetterLombokMyBatis
0 likes · 7 min read
Why Lombok’s Getter/Setter Breaks MyBatis and EasyExcel: Hidden Pitfalls Explained
Su San Talks Tech
Su San Talks Tech
Feb 3, 2023 · Backend Development

Efficiently Export Millions of Rows to Excel Using Async and EasyExcel

This article details a robust solution for exporting massive MySQL datasets—potentially millions of rows—to Excel by leveraging asynchronous processing with jobs or MQ, the memory‑efficient EasyExcel library, pagination, multi‑sheet handling, OSS storage, and WebSocket notifications, ensuring performance and usability.

async-processingeasyexcelexcel-export
0 likes · 17 min read
Efficiently Export Millions of Rows to Excel Using Async and EasyExcel
Top Architect
Top Architect
Jan 31, 2023 · Backend Development

Handling Large-Scale Excel Import/Export with POI and EasyExcel in Java

This article explains how to efficiently import and export massive Excel datasets in Java by comparing POI implementations, selecting the appropriate workbook type, and using EasyExcel with batch processing, pagination, and JDBC transactions to achieve high performance for hundreds of thousands to millions of rows.

Data ExportExcelPOI
0 likes · 23 min read
Handling Large-Scale Excel Import/Export with POI and EasyExcel in Java
Java High-Performance Architecture
Java High-Performance Architecture
Dec 4, 2022 · Backend Development

How to Efficiently Import and Export Millions of Records with EasyExcel and POI

This article explains the challenges of large‑scale Excel import/export in Java, compares POI workbook implementations, introduces EasyExcel for high‑performance handling of hundreds of thousands to millions of rows, and provides detailed code examples for batch querying, sheet management, and JDBC batch insertion with transaction control.

Batch ProcessingData ExportJDBC
0 likes · 23 min read
How to Efficiently Import and Export Millions of Records with EasyExcel and POI
Java Architect Essentials
Java Architect Essentials
Nov 24, 2022 · Backend Development

How to Efficiently Import and Export Millions of Rows with POI and EasyExcel

This article explains how to overcome the limitations of traditional Apache POI when handling massive Excel import/export tasks by comparing POI workbook types, selecting the appropriate one, and using EasyExcel together with batch database queries and JDBC transactions to process up to three million rows efficiently.

Apache POIBatch ProcessingJDBC
0 likes · 23 min read
How to Efficiently Import and Export Millions of Rows with POI and EasyExcel
Top Architect
Top Architect
Nov 22, 2022 · Big Data

Efficient Massive Excel Import/Export with POI and EasyExcel in Java

This article explains how to efficiently import and export massive datasets (up to millions of rows) between Excel and databases using Apache POI, SXSSF, and Alibaba's EasyExcel, comparing workbook types, outlining performance considerations, and providing Java code examples for batch processing, paging, and transaction management.

Batch ProcessingBig DataExcel
0 likes · 23 min read
Efficient Massive Excel Import/Export with POI and EasyExcel in Java
Java Architect Essentials
Java Architect Essentials
Nov 14, 2022 · Big Data

Efficient Import and Export of Millions of Records Using Apache POI and EasyExcel

This article explains how to handle massive Excel import and export tasks in Java by comparing traditional POI implementations, selecting the appropriate Workbook type based on data volume, and leveraging Alibaba's EasyExcel library together with batch JDBC operations to process over three million rows with minimal memory usage and high performance.

Apache POIBig DataData Export
0 likes · 22 min read
Efficient Import and Export of Millions of Records Using Apache POI and EasyExcel
Architect's Tech Stack
Architect's Tech Stack
Oct 26, 2022 · Backend Development

Using EasyExcel Spring Boot Starter for Excel Import, Export and Validation

This article introduces the EasyExcel‑Spring‑Boot‑Starter project, explains the limitations of POI and EasyExcel, shows how to integrate it into a Spring Boot application with Maven dependencies, demonstrates Excel import and export APIs, and provides comprehensive validation and error‑handling mechanisms for robust backend development.

Excel Importeasyexcelexcel-export
0 likes · 10 min read
Using EasyExcel Spring Boot Starter for Excel Import, Export and Validation
Su San Talks Tech
Su San Talks Tech
Oct 6, 2022 · Backend Development

How to Efficiently Import and Export Millions of Records with EasyExcel and POI

This article explains how to handle massive Excel import and export tasks in Java by comparing POI's HSSFWorkbook, XSSFWorkbook, and SXSSFWorkbook, selecting the right implementation, and using Alibaba's EasyExcel together with batch queries and JDBC batch inserts to process three million rows efficiently without memory overflow.

Apache POIData Exportdata import
0 likes · 20 min read
How to Efficiently Import and Export Millions of Records with EasyExcel and POI
Architect
Architect
Oct 3, 2022 · Big Data

Efficient Import and Export of Massive Data Using POI and EasyExcel

This article explains how to handle large‑scale Excel import and export in Java by comparing traditional POI workbooks, selecting the appropriate implementation based on data volume and requirements, and presenting a high‑performance solution with EasyExcel, batch processing, and JDBC transactions for hundreds of millions of rows.

Data ExportPOIdata import
0 likes · 22 min read
Efficient Import and Export of Massive Data Using POI and EasyExcel
macrozheng
macrozheng
Jan 6, 2022 · Backend Development

Boost Your SpringBoot Apps with EasyExcel: Fast, Low-Memory Excel Import/Export

This article introduces Alibaba's EasyExcel library, demonstrates how to integrate it into SpringBoot, and provides step‑by‑step code examples for simple export, import, and complex one‑to‑many export using custom merge strategies, highlighting its performance advantages over EasyPoi.

Excel ImportSpringBooteasyexcel
0 likes · 18 min read
Boost Your SpringBoot Apps with EasyExcel: Fast, Low-Memory Excel Import/Export
Java Architect Essentials
Java Architect Essentials
Dec 16, 2021 · Backend Development

How to Efficiently Export Millions of Records to Excel with Alibaba EasyExcel

This article explains why traditional Excel export methods cause memory overflow, introduces Alibaba's EasyExcel library that keeps memory usage in kilobytes, and provides step‑by‑step Maven setup, POJO definitions, and code examples for exporting small, medium, and massive data sets in a Spring Boot environment.

Large DataSpring Booteasyexcel
0 likes · 21 min read
How to Efficiently Export Millions of Records to Excel with Alibaba EasyExcel
Programmer DD
Programmer DD
Nov 22, 2021 · Backend Development

Master EasyExcel: Fast, Low‑Memory Excel Import/Export in Java

This guide explains how to use Alibaba's EasyExcel library for efficient, low‑memory Excel import and export in Java, covering its core features, common annotations, Maven dependencies, listener implementation, and practical code examples for both HTTP‑based and local file operations.

ExcelExportImport
0 likes · 7 min read
Master EasyExcel: Fast, Low‑Memory Excel Import/Export in Java
Architect's Tech Stack
Architect's Tech Stack
Oct 21, 2021 · Backend Development

Using Alibaba EasyExcel for Reading and Writing Excel Files in Java

This article provides a comprehensive guide on integrating Alibaba's EasyExcel library into Java projects, covering environment setup, reading Excel files with and without sheet specifications for datasets smaller or larger than 1000 rows, exporting data with simple and model‑mapped approaches, handling multiple sheets, and includes full source code examples and a test suite.

ExcelFileIOSpringBoot
0 likes · 15 min read
Using Alibaba EasyExcel for Reading and Writing Excel Files in Java
Programmer DD
Programmer DD
Oct 18, 2021 · Backend Development

Master Excel Processing in Java with Alibaba EasyExcel: Setup, Read, and Export

This guide walks through integrating Alibaba's EasyExcel library into a Java project, covering Maven dependencies, environment setup, reading Excel files with less or more than 1000 rows (including custom sheet and row offsets), and exporting data using simple lists, model mapping, and multiple sheets, all illustrated with complete code examples.

Data ExportExcelFile I/O
0 likes · 17 min read
Master Excel Processing in Java with Alibaba EasyExcel: Setup, Read, and Export
Code Ape Tech Column
Code Ape Tech Column
Sep 28, 2021 · Backend Development

Using EasyExcel for Excel Import and Export in Java

This article introduces the EasyExcel library for Java, demonstrating how to quickly set up Excel import and export with Maven dependencies, entity annotations, custom converters, listeners for validation, and controller code for both reading and writing data, along with common API usage and examples.

DataValidationExcelImportExport
0 likes · 9 min read
Using EasyExcel for Excel Import and Export in Java
Top Architect
Top Architect
Sep 23, 2021 · Backend Development

Using Alibaba EasyExcel for Reading and Writing Excel Files in Java

This article provides a comprehensive guide on integrating Alibaba's EasyExcel library in Java projects, covering environment setup, reading Excel files with less or more than 1000 rows, exporting data with and without model mapping, handling multiple sheets, and includes full code examples for each operation.

ExcelFile I/OSpring Boot
0 likes · 14 min read
Using Alibaba EasyExcel for Reading and Writing Excel Files in Java
Code Ape Tech Column
Code Ape Tech Column
Jul 8, 2021 · Backend Development

How to Export Millions of Records to Excel Efficiently with Alibaba EasyExcel

This article explains the challenges of exporting massive datasets from backend systems, compares a custom SXSSFWorkbook solution with Alibaba's EasyExcel library, and provides detailed code examples for handling small, medium, and huge data volumes while keeping memory usage low and performance high.

Large Dataeasyexcelexcel-export
0 likes · 14 min read
How to Export Millions of Records to Excel Efficiently with Alibaba EasyExcel
Top Architect
Top Architect
Jun 10, 2021 · Backend Development

Optimizing Large Excel Import Performance in Java Backend Applications

This article details a step‑by‑step optimization of a Java backend Excel import pipeline, covering requirement analysis, performance bottlenecks, caching strategies, batch insertion techniques, parallel processing, and practical code examples to reduce a 10‑minute import to under two minutes.

Batch InsertExceleasyexcel
0 likes · 13 min read
Optimizing Large Excel Import Performance in Java Backend Applications
Java Interview Crash Guide
Java Interview Crash Guide
May 29, 2021 · Backend Development

How to Export Massive Excel Files Efficiently with Alibaba EasyExcel in Java

This article explains how to replace a custom, memory‑intensive Excel export implementation with Alibaba's EasyExcel library, demonstrating Maven setup, POJO definition, and three test scenarios for small, medium, and huge data sets, while offering performance tips and production‑ready code for Java backend systems.

Large Databackend-developmenteasyexcel
0 likes · 17 min read
How to Export Massive Excel Files Efficiently with Alibaba EasyExcel in Java
Programmer DD
Programmer DD
Mar 3, 2021 · Backend Development

How to Speed Up Large Excel Imports in Java: From POI to EasyExcel and Parallel Insertion

This article walks through a step‑by‑step optimization of a Java‑based Excel import pipeline, covering the transition from raw POI to EasyPOI and EasyExcel, caching database lookups, batch inserts, optimal batch sizes, parallel streams, and logging reductions to achieve sub‑minute import times for hundreds of thousands of rows.

BackendExcelParallelStream
0 likes · 12 min read
How to Speed Up Large Excel Imports in Java: From POI to EasyExcel and Parallel Insertion
Code Ape Tech Column
Code Ape Tech Column
Mar 1, 2021 · Backend Development

Optimizing Large‑Scale Excel Import in Java: From POI to EasyExcel with Caching, Batch Inserts, and Parallel Streams

This article describes how to dramatically speed up the import of massive Excel files in a Java backend by replacing raw POI with EasyExcel, caching database lookups, using MySQL batch inserts, and employing parallel streams to achieve sub‑minute processing for hundreds of thousands of rows.

Batch InsertExcel ImportMyBatis
0 likes · 12 min read
Optimizing Large‑Scale Excel Import in Java: From POI to EasyExcel with Caching, Batch Inserts, and Parallel Streams
Selected Java Interview Questions
Selected Java Interview Questions
Jan 17, 2021 · Backend Development

Lombok Getter/Setter Pitfalls with MyBatis and @Accessor(chain=true) Issues in EasyExcel

This article explains why Lombok-generated getter/setter methods for fields whose second character is uppercase can cause MyBatis to store null values, shows the MyBatis PropertyNamer logic that leads to the problem, and also describes how the @Accessor(chain=true) annotation interferes with EasyExcel's reflection‑based export, offering practical workarounds for both issues.

GetterSetterLombokMyBatis
0 likes · 9 min read
Lombok Getter/Setter Pitfalls with MyBatis and @Accessor(chain=true) Issues in EasyExcel
Architecture Digest
Architecture Digest
Jan 6, 2021 · Backend Development

Optimizing Large-Scale Excel Import Performance in Java Backend Applications

This article details a step‑by‑step optimization of a Java backend Excel import pipeline, covering data validation caching, batch insertion with MySQL VALUES, switching to EasyExcel, parallel stream insertion, and logging reduction to achieve sub‑minute import times for hundreds of thousands of rows.

ExcelMyBatisParallelStream
0 likes · 11 min read
Optimizing Large-Scale Excel Import Performance in Java Backend Applications
Architecture Digest
Architecture Digest
Sep 15, 2020 · Databases

Optimizing Large‑Scale Excel Import in Java: From POI to EasyExcel, Caching, Batch Inserts and Parallel Processing

This article details how to dramatically speed up Excel‑driven fee‑record imports by replacing naïve POI row‑by‑row processing with EasyExcel, caching database look‑ups, using MySQL batch INSERTs, and finally applying parallel streams for multi‑threaded insertion, while also trimming excessive logging.

ExcelMyBatisParallelProcessing
0 likes · 12 min read
Optimizing Large‑Scale Excel Import in Java: From POI to EasyExcel, Caching, Batch Inserts and Parallel Processing
Java Architecture Diary
Java Architecture Diary
Mar 31, 2020 · Backend Development

Master Fast, Low-Memory Excel Export in Spring Boot with EasyExcel

This guide introduces EasyExcel, a Java library for memory‑efficient Excel read/write, shows how to add the Spring Boot starter dependency, and demonstrates basic, custom, multi‑sheet, password‑protected, and template‑based export techniques using the @ResponseExcel annotation.

Spring Bootannotationeasyexcel
0 likes · 6 min read
Master Fast, Low-Memory Excel Export in Spring Boot with EasyExcel
Programmer DD
Programmer DD
Nov 4, 2019 · Backend Development

Master Efficient Excel Imports in Java with EasyExcel and Spring Boot

This article explains how Java backend developers can replace memory‑heavy Apache POI with EasyExcel for fast, low‑memory Excel imports, covering basic reading, custom converters for gender and dates, and multiple Spring Boot integration patterns including controllers, listeners, constructor injection and lambda‑based approaches.

Batch ProcessingExcelSpring Boot
0 likes · 12 min read
Master Efficient Excel Imports in Java with EasyExcel and Spring Boot
Java Captain
Java Captain
Sep 22, 2018 · Backend Development

EasyExcel Method Encapsulation for Simplified Excel Import and Export in Java

This article introduces a lightweight Java wrapper around Alibaba's EasyExcel library that enables one‑line Excel import and export, explains required Maven dependencies, essential utility classes, and provides complete code examples for reading, writing single‑sheet and multi‑sheet workbooks with custom model mappings.

Excel ImportSpring MVCeasyexcel
0 likes · 8 min read
EasyExcel Method Encapsulation for Simplified Excel Import and Export in Java