Tagged articles
Excel Export
44 articles · Page 1 of 1
This tutorial demonstrates how to use JXLS 2.11.0 for complex Excel exports in Java, covering Maven setup, template creation with xlsx format, and key expressions like jx:area, jx:each, jx:mergeCells, and dynamic columns with code examples.
Apache POIDynamic ColumnsExcel Export
0 likes · 9 min read

The author describes how exporting 500k order records caused a 2GB heap OOM, then fixed it by replacing XSSFWorkbook with streaming SXSSFWorkbook, switching from full entity loading to cursor-based batch queries with DTOs, reusing cell styles, and finally decoupling large exports from HTTP requests via async task processing.
Apache POICursor PaginationExcel Export
0 likes · 14 min read

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.
EasyExcelExcel ExportJava
0 likes · 16 min read

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.
EasyExcelExcel ExportJava
0 likes · 15 min read


ITPUBJun 9, 2026 · Backend Development
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.
BackendConcurrencyEasyExcel
0 likes · 11 min read

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.
BackendEasyExcelExcel Export
0 likes · 11 min read

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.
EasyExcelExcel ExportJava
0 likes · 14 min read

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.
EasyExcelExcel ExportJava
0 likes · 15 min read

This article explains how a large e‑commerce platform implements a high‑performance, asynchronous Excel export mechanism using annotation‑driven declarative programming, AOP interception, Quartz scheduling, RocketMQ messaging, and OSS storage to handle massive data sets without blocking user requests.
Asynchronous ProcessingExcel ExportQuartz
0 likes · 10 min read

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.
EasyExcelExcel ExportJava
0 likes · 10 min read

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.
EasyExcelExcel ExportJava
0 likes · 11 min read

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.
EasyExcelExcel ExportJava
0 likes · 9 min read

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.
Custom AnnotationEasyExcelExcel Export
0 likes · 11 min read

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.
EasyExcelExcel ExportJava backend
0 likes · 20 min read

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

Learn how to overcome memory and speed bottlenecks when exporting massive datasets to Excel by using streaming APIs like SXSSFWorkbook and EasyExcel, optimizing database pagination, tuning JVM and connection pools, and applying asynchronous shard processing to achieve stable sub‑200 MB memory usage for millions of rows.
Asynchronous ProcessingDatabase paginationExcel Export
0 likes · 10 min read

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

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

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

This article introduces the JXLS library for Java, explains how to add Maven dependencies, provides backend utility and controller code for exporting Excel files, and details common XLS expressions such as jx:area, jx:each, jx:mergeCells, and dynamic column handling to simplify complex Excel report generation.
BackendDynamic ColumnsExcel Export
0 likes · 8 min read

A Java developer recounts how an unexpected Excel export failure was traced to mismatched EasyPOI and Apache POI versions, the impact of Maven's -U flag, and the step‑by‑step resolution involving dependency alignment and careful version selection.
Apache POIDependency ConflictEasyPOI
0 likes · 11 min read

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.
EasyExcelExcel Exporthtml-parsing
0 likes · 9 min read

The article shows how to generically export any Java object's data to an Excel‑compatible CSV file by using reflection to convert objects into maps, building headers (optionally via a @JcExcelName annotation) and writing the result with a reusable utility class and Maven‑managed Apache POI, FastJSON, and Commons‑IO dependencies, illustrated through SpringBoot controller and main‑method examples.
CSVExcel ExportJava
0 likes · 10 min read

This article demonstrates a step‑by‑step method for exporting a list of unknown Java objects to an Excel/CSV file by leveraging reflection to dynamically generate headers and rows, complete with Maven dependencies, utility code, usage examples, and an extensible annotation‑based approach.
CSVExcel ExportJava
0 likes · 11 min read

This article introduces the JXLS library for Java, explains how to add Maven dependencies, provides backend utility and controller code for exporting Excel files, and details template creation and common JXLS expressions such as jx:area, jx:each, jx:mergeCells, and dynamic column handling.
Excel ExportJXLSJava
0 likes · 6 min read

This tutorial explains how to generate export classes in Laravel, implement array, query, or collection exports, customize column headers, download files directly, specify file names, formats, response headers, store exports to disk, set document options, and reuse exports with traits, all using the Lysice XlsWriter package.
Excel ExportLaravelLysice
0 likes · 4 min read

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.
Custom ConverterEasyExcelExcel Export
0 likes · 13 min read

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.
Custom MergeEasyExcelExcel Export
0 likes · 14 min read

This article explains how to build a reusable Java utility for exporting large Excel reports using Apache POI, covering header configuration, data transformation, cell formatting, multithreaded data retrieval, asynchronous handling of long‑running exports, and provides full source snippets and SQL schema examples.
Apache POIExcel ExportJava
0 likes · 13 min read

This article explains how to build a generic Java utility that exports any list of objects to an Excel‑compatible CSV file by using reflection to extract field names for headers and values for rows, includes Maven dependencies, custom annotations, and practical usage examples.
AnnotationsCSVExcel Export
0 likes · 9 min read

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.
EasyExcelExcel ExportJava
0 likes · 17 min read

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.
EasyExcelExcel ExportJava
0 likes · 10 min read

This article explains how to leverage Web Workers and OffscreenCanvas to offload heavy Excel file generation and bulk image compression from the main thread, improving UI responsiveness and reducing rendering stalls in typical backend‑admin web applications.
Excel ExportWeb Workersimage compression
0 likes · 14 min read

This article demonstrates how to use EasyPOI to export Excel files with dynamically generated column headers and data rows in Java, covering dependency configuration, header creation, data population, merging cells, utility methods, DTO definitions, and a complete test case.
Dynamic ColumnsEasyPOIExcel Export
0 likes · 13 min read

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.
EasyExcelExcel ExportJava
0 likes · 21 min read

PaddleOCR v2.2 launches PP‑Structure, a Python‑installable toolkit that combines PP‑YOLO v2 layout analysis (classifying text, title, table, image, list) with RARE‑based table recognition to extract structured content and export editable Excel files, while supporting custom training and simple command‑line use.
AIExcel ExportPP-Structure
0 likes · 8 min read

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.
EasyExcelExcel ExportJava
0 likes · 14 min read

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.
EasyExcelExcel ExportJava
0 likes · 17 min read

This article demonstrates how to export database records to an Excel file using PHP, detailing the data retrieval, formatting, and a reusable createtable function that outputs the spreadsheet with appropriate headers for download.
Excel Export
0 likes · 3 min read

This tutorial walks through setting up a Windows‑based PHP development environment, installing ThinkPHP 6.0 and the PhpSpreadsheet library, configuring Nginx and the database, and providing complete code to query MySQL data and export it as an Excel file.
Excel ExportPHPThinkPHP
0 likes · 3 min read

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.
EasyExcelExcel ExportJava
0 likes · 6 min read

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.
EasyExcelExcel ExportJava
0 likes · 8 min read

This article demonstrates how to use Apache POI in Java to export collections of JavaBean objects to Excel files, covering generic reflection‑based implementation, styling, handling of dates, booleans, images, and integration with a servlet for download.
Apache POIExcel ExportJava
0 likes · 12 min read


Aotu LabApr 15, 2016 · Backend Development
This guide compares popular Node.js npm packages for Excel file handling, recommends using js‑xlsx for parsing and excel‑export for generation, and provides detailed installation steps, core concepts, code examples, and a complete workflow for reading, converting to JSON, and writing Excel files on both server and browser environments.
BackendExcelExcel Export
0 likes · 13 min read
