BestHub
Sign in
Tagged articles

Excel Export

43 articles · Page 1 of 1
LuTiao Programming
LuTiao Programming
Sep 30, 2026 · Backend Development

Spring Boot Excel Export OOM: Replacing XSSFWorkbook with SXSSFWorkbook and Batch Processing

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 POIAsync ProcessingBatch Processing
0 likes · 14 min read
Spring Boot Excel Export OOM: Replacing XSSFWorkbook with SXSSFWorkbook and Batch Processing
Java Tech Enthusiast
Java Tech Enthusiast
Aug 2, 2026 · Backend Development

Boost Excel Import/Export Performance in Spring Boot with EasyExcel

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
Boost Excel Import/Export Performance in Spring Boot with EasyExcel
Java Tech Workshop
Java Tech Workshop
Jul 27, 2026 · Backend Development

Spring Boot + EasyExcel: High‑Performance, Elegant Excel Import/Export

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
Spring Boot + EasyExcel: High‑Performance, Elegant Excel Import/Export
ITPUB
ITPUB
Jun 9, 2026 · Backend Development

How to Prevent Server Crashes from Concurrent Excel Exports with a Queue

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
How to Prevent Server Crashes from Concurrent Excel Exports with a Queue
Top Architect
Top Architect
Jun 9, 2026 · Backend Development

Master SpringBoot Excel Export with EasyExcel: A Complete Guide

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.

BackendData ExportEasyExcel
0 likes · 11 min read
Master SpringBoot Excel Export with EasyExcel: A Complete Guide
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.

EasyExcelExcel ExportJava
0 likes · 14 min read
Quick Start Guide to Using EasyExcel with Spring Boot 3 (Verified)
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)
Su San Talks Tech
Su San Talks Tech
Nov 5, 2025 · Backend Development

How to Build a Scalable Asynchronous Excel Export System for Large E‑Commerce

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.

Excel ExportRocketMQSpring
0 likes · 10 min read
How to Build a Scalable Asynchronous Excel Export System for Large E‑Commerce
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.

EasyExcelExcel ExportJava
0 likes · 10 min read
Master EasyExcel: From Setup to Advanced Export Techniques in Java
Senior Xiao Ying
Senior Xiao Ying
Sep 25, 2025 · Backend Development

How to Export Arbitrary Excel Files with Spring Boot and EasyExcel Annotations

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.

Async ProcessingEasyExcelExcel Export
0 likes · 11 min read
How to Export Arbitrary Excel Files with Spring Boot and EasyExcel Annotations
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.

EasyExcelExcel ExportJava 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
Su San Talks Tech
Su San Talks Tech
May 4, 2025 · Backend Development

How to Export Millions of Excel Rows in Seconds: High‑Performance Java Strategies

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.

Database paginationExcel ExportJVM Tuning
0 likes · 10 min read
How to Export Millions of Excel Rows in Seconds: High‑Performance Java Strategies
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 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
Architect's Guide
Architect's Guide
Oct 17, 2024 · Backend Development

Using JXLS for Complex Excel Export in Java Backend Applications

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
Using JXLS for Complex Excel Export in Java Backend Applications
Java Tech Enthusiast
Java Tech Enthusiast
Feb 14, 2024 · Backend Development

Generic Excel Export for Arbitrary Java Objects via Reflection

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
Generic Excel Export for Arbitrary Java Objects via Reflection
Java Backend Technology
Java Backend Technology
Jan 24, 2024 · Backend Development

How to Export Any Java Object List to Excel Using Reflection and CSV

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
How to Export Any Java Object List to Excel Using Reflection and CSV
Selected Java Interview Questions
Selected Java Interview Questions
Aug 25, 2023 · Backend Development

Using JXLS for Complex Excel Export in Java

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 ExportJavaMaven
0 likes · 6 min read
Using JXLS for Complex Excel Export in Java
Laravel Tech Community
Laravel Tech Community
Jul 16, 2023 · Backend Development

Creating Export Classes and Exporting Data with Laravel Excel (Lysice XlsWriter)

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
Creating Export Classes and Exporting Data with Laravel Excel (Lysice XlsWriter)
Selected Java Interview Questions
Selected Java Interview Questions
Apr 26, 2023 · Backend Development

Implementing a Flexible Excel Export Utility with Apache POI in Java

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.

@AsyncApache POIExcel Export
0 likes · 13 min read
Implementing a Flexible Excel Export Utility with Apache POI in Java
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
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.

EasyExcelExcel ExportJava
0 likes · 10 min read
Using EasyExcel Spring Boot Starter for Excel Import, Export and Validation
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.

EasyExcelExcel ExportJava
0 likes · 21 min read
How to Efficiently Export Millions of Records to Excel with Alibaba EasyExcel
Baidu Geek Talk
Baidu Geek Talk
Aug 4, 2021 · Artificial Intelligence

PaddleOCR v2.2 Release: PP-Structure for Document Layout Analysis and Table Recognition

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
PaddleOCR v2.2 Release: PP-Structure for Document Layout Analysis and Table Recognition
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.

EasyExcelExcel ExportJava
0 likes · 17 min read
How to Export Massive Excel Files Efficiently with Alibaba EasyExcel in Java
php Courses
php Courses
Apr 21, 2021 · Backend Development

Exporting Database Data to Excel with PHP

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
Exporting Database Data to Excel with PHP
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.

EasyExcelExcel ExportJava
0 likes · 6 min read
Master Fast, Low-Memory Excel Export in Spring Boot with EasyExcel
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.

EasyExcelExcel ExportJava
0 likes · 8 min read
EasyExcel Method Encapsulation for Simplified Excel Import and Export in Java
Java Captain
Java Captain
Jun 20, 2018 · Backend Development

Export Excel Files in Java Using Apache POI

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 POIData ExportExcel Export
0 likes · 12 min read
Export Excel Files in Java Using Apache POI
Aotu Lab
Aotu Lab
Apr 15, 2016 · Backend Development

Master Excel File Handling in Node.js with js-xlsx and excel-export

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
Master Excel File Handling in Node.js with js-xlsx and excel-export