BestHub
Sign in
Tagged articles
37 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.

Backend DevelopmentExcel ImportJava
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.

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

QuartzRocketMQTask Queue
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.

JavaSpring Booteasyexcel
0 likes · 10 min read
Master EasyExcel: From Setup to Advanced Export Techniques in Java
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.

Javaeasyexcelexcel-export
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 paginationJavaStreaming
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.

JavaPerformance OptimizationThreadPool
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 MergingJavaconcurrency
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 MergingJavaconcurrency
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 ColumnsJava
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.

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

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

Backend DevelopmentJavaexcel-export
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.

Backend DevelopmentLaravelLysice
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.

Apache POIAsyncBackend Development
0 likes · 13 min read
Implementing a Flexible Excel Export Utility with Apache POI in Java
Architect's Guide
Architect's Guide
Mar 30, 2023 · Backend Development

Universal Java Class-to-Excel Export Using Reflection and CSV Formatting

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.

Backend DevelopmentCSVJava
0 likes · 9 min read
Universal Java Class-to-Excel Export Using Reflection and CSV Formatting
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.

Javaasync-processingeasyexcel
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.

Excel ImportJavaeasyexcel
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.

JavaLarge DataSpring Boot
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.

AIDeep LearningPP-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.

Backend DevelopmentJavaLarge Data
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.

JavaSpring Bootannotation
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.

Excel ImportJavaSpring MVC
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 ExportJava
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.

BackendExcelJavaScript
0 likes · 13 min read
Master Excel File Handling in Node.js with js-xlsx and excel-export