This article introduces FastExcel, a high-performance Java Excel library created by the original EasyExcel author, featuring streaming read/write, full API compatibility, new PDF conversion, and code examples for entity mapping, event listeners, and large-file processing.
This article introduces FastExcel, a high-performance Java library for Excel processing that succeeds EasyExcel, detailing its streaming API, entity mapping, read/write code examples, PDF conversion, and performance advantages over its predecessor.
This article details a production-ready engineering approach for importing hundreds of thousands of Excel rows using Spring Boot and EasyExcel, covering streaming parsing, batch validation, async task isolation, idempotency, error reporting, and operational concerns like logging and temp file cleanup.
FileMagic validation throws IOException on real Excel uploads because Tomcat's default FileInputStream lacks mark/reset support, unlike test ByteArrayInputStream; wrapping with BufferedInputStream fixes it, and regression tests must simulate real stream types to catch this.
This article traces the evolution from Alibaba's archived EasyExcel to Apache Fesod (incubating), detailing migration steps, API compatibility, performance benchmarks showing Fesod's superior memory efficiency, and selection recommendations for Java Excel processing.
This article explains why EasyExcel was archived, introduces FastExcel as a rewrite, details its donation to Apache as Fesod, provides migration steps with code examples, compares performance against alternatives, and recommends Apache Fesod for new and existing projects due to its streaming API, low GC overhead, and Apache Foundation backing.
This article explains why EasyExcel was archived, introduces its successor FastExcel (now Apache Fesod), compares performance and features, provides migration steps with code examples, and recommends Apache Fesod for new and existing projects due to its streaming API, memory efficiency, and Apache Foundation backing.
FastExcel, the successor to EasyExcel, is now an Apache project offering high‑performance, low‑memory Excel read/write, streaming support, full API compatibility, PDF conversion, and detailed usage examples, making it a compelling choice for Java developers handling large Excel datasets.
The article explains why native Apache POI causes memory‑explosion and maintenance headaches for Excel import/export in Java back‑ends, introduces Alibaba's EasyExcel as a low‑memory, annotation‑driven alternative, and provides step‑by‑step Spring Boot code for exporting, importing, custom conversion, validation, complex headers, pagination, template filling, and common pitfalls with concrete solutions.
This article explains why native Apache POI causes memory‑heavy, boilerplate Excel import/export code, introduces Alibaba's EasyExcel as a low‑memory, annotation‑driven alternative, and provides step‑by‑step Spring Boot examples for exporting, importing, custom conversion, validation, pagination, and template filling while highlighting common pitfalls and solutions.
The article explains why concurrent Excel exports can overload a Java backend, describes a FIFO queue with a fixed capacity to serialize export tasks, shows the full implementation with Spring, EasyExcel and synchronized wait/notify, and discusses test results and remaining limitations.
The article explains why simultaneous Excel exports can overload a server, proposes a fixed‑size FIFO queue to serialize export tasks, and provides a complete Spring‑Boot implementation—including the ExportQueue, abstract export logic with EasyExcel, and a test controller—to demonstrate the queuing mechanism in action.
This guide walks through integrating EasyExcel with Spring Boot, covering Maven setup, entity definition, utility class creation, basic and advanced export scenarios such as complex headers, cell merging, custom formatting, and large‑scale paging, plus common pitfalls like dependency conflicts and annotation misuse.
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.
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.
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.
This article explains how Lombok’s unconventional getter/setter method names cause MyBatis to store enum fields as null, why the @Accessor(chain=true) annotation breaks EasyExcel exports, and provides concrete code‑level solutions to resolve both issues in Java backend projects.
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.
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.
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.
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.
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.
This article explains how Lombok generates getter and setter method names for fields with a lowercase first letter and uppercase second letter, causing mismatches with MyBatis property parsing and EasyExcel’s cglib reflection, and provides practical solutions.
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.
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.
This article explains how Lombok’s automatic getter/setter generation can cause MyBatis to store enum fields as null, details the underlying JavaBeans naming conflict, and also reveals why EasyExcel fails with @Accessor(chain=true) annotations, offering practical solutions for both problems.
This article details a step‑by‑step optimization of a large‑scale Excel import workflow, covering the transition from raw POI to EasyExcel, caching database lookups, batch INSERT statements, and parallel stream processing to reduce a 100k‑row import from minutes to under two minutes.
This guide explains how to integrate Alibaba's EasyExcel library into a Spring Boot project to perform low‑memory, high‑performance Excel import and export using annotation‑based entity mapping, listener mode, dynamic headers, async processing, validation, templates, and encryption.
This article walks Java developers through integrating EasyExcel, defining data models, creating utility classes, handling complex headers, merging cells, custom formatting, and large‑scale streaming exports, while sharing practical pitfalls and solutions for robust Excel generation.
This article demonstrates how to simplify and accelerate Excel export in Spring Boot 3 by using Alibaba's EasyExcel library together with a custom @ExportExcel annotation, a dedicated return‑value handler, and example controller code for static, dynamic, and template‑based exports.
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.
This article explains how to use Alibaba's EasyExcel library in Java to perform fast, flexible Excel data imports, covering custom listeners, validation, handling complex sheet structures, and providing reusable utility classes for robust backend data processing.
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.
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.
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.
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.
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.
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.
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.
FastExcel is a Java library that builds on EasyExcel to provide high‑performance, low‑memory Excel read/write, stream processing, PDF conversion and a simple API, with detailed usage examples, code snippets, and a comparison of its advantages over EasyExcel.
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.
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.
The article announces EasyExcel's shift to maintenance mode, introduces its successor FastExcel with high‑performance features, and provides detailed migration steps, dependency configurations, and code examples for reading and writing Excel files in Java.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
The article demonstrates how to avoid blocking SpringBoot services during massive Excel exports by splitting data, using CompletableFuture with a ThreadPoolTaskExecutor to generate multiple Excel files concurrently via EasyExcel, then compressing them into a ZIP for client download, including full code and resource‑cleanup details.
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.
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.
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.
This article demonstrates how to use Jsoup to fetch and parse HTML content from a web page, extract specific table data via CSS selectors, map the data to Java objects, and efficiently write the results to an Excel file with EasyExcel, highlighting memory advantages over POI.
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.
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.
This article details how to dramatically speed up the import of massive Excel files (over 100,000 rows) into a Java backend by switching to EasyExcel, caching database lookups, using batch VALUES inserts, and parallelizing the write operations with functional utilities.
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.
This article explains how to build a high‑performance, million‑row Excel export feature in Java using SpringBoot, EasyExcel, asynchronous job or MQ processing, pagination, multi‑sheet handling, OSS storage, and WebSocket notifications to avoid timeouts, OOM errors, and improve user experience.
The article explains why Apache POI loads entire .xlsx zip files into memory causing OOM, demonstrates the issue with code examples, and shows how switching to EasyExcel's streaming read dramatically reduces memory usage while handling large Excel files in Java.
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.
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.
Learn how to efficiently read and write large Excel files in Java using EasyExcel, covering dependency setup, entity definitions, core annotations, custom converters, complex one‑to‑many export strategies, custom merge annotations, and practical import/export API examples with full code snippets.
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.
This article provides a comprehensive tutorial on EasyExcel, a Java library for fast and memory‑efficient Excel processing, covering dependency setup, simple and complex export examples with custom annotations and merge strategies, import handling, and reference resources.
This tutorial explains how to collect 2022 county‑level GDP and public budget data from the Chinese National Bureau of Statistics using Java's Jsoup library, transform the HTML tables into structured Excel files with EasyExcel, and provides complete source code and step‑by‑step analysis.
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.
This article explains how Lombok's generated getter and setter method names can conflict with MyBatis property resolution and cause issues when using EasyExcel's @Accessor(chain=true) annotation, and provides detailed code examples and solutions to resolve these incompatibilities.
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.
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.
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.
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.
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.
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.
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.
This article analyzes traditional POI implementations, compares their strengths and weaknesses, and presents a high‑performance solution using EasyExcel for exporting and importing up to 3 million rows, including batch querying, sheet management, JDBC batch inserts, and detailed performance benchmarks.
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.
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.
This article provides a step‑by‑step Java tutorial for generating PDF and Excel files, dynamically inserting data from backend entities, and exporting them, including detailed configuration, code examples using iText and EasyExcel, and testing procedures.
This article introduces Alibaba's EasyExcel library, explains its memory‑efficient design, lists its main advantages and common annotations, provides Maven dependencies, and demonstrates import and export code snippets for Java backend applications.
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.
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.
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.
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.
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.
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.
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.
This article details how to dramatically speed up the import of massive Excel fee‑record files in a Java backend by switching to EasyExcel, caching database lookups, using batch INSERT statements, and applying parallel streams while eliminating excessive logging.
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.
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.
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.
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.
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.
This guide walks through creating PDF templates, inserting dynamic data, and exporting both PDF and Excel files in a Java backend using iText for PDFs and EasyExcel for spreadsheets, complete with code examples and testing screenshots.