Tagged articles

Excel import

22 articles · Page 1 of 1

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.

AnnotationEasyExcelExcel export

0 likes · 16 min read

Boost Excel Import/Export Performance in Spring Boot with EasyExcel

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 exportExcel import

0 likes · 15 min read

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

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 exportExcel import

0 likes · 14 min read

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

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

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 exportExcel import

0 likes · 20 min read

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

Selected Java Interview Questions

Jun 18, 2025 · Backend Development

Master Efficient Excel Imports in Java with EasyExcel and Custom Listeners

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.

EasyExcelExcel importbackend

0 likes · 10 min read

Master Efficient Excel Imports in Java with EasyExcel and Custom Listeners

Su San Talks Tech

Apr 2, 2025 · Backend Development

How to Import Millions of Excel Rows in Seconds: 4 Proven Performance Hacks

This article analyzes why traditional Excel import methods crash under massive loads and presents four practical optimization techniques—including streaming parsing, batch inserts, asynchronous processing, and parallel sharding—backed by code samples, configuration tips, and real‑world performance benchmarks for importing millions of rows efficiently.

Batch ProcessingExcel importSpring

0 likes · 10 min read

How to Import Millions of Excel Rows in Seconds: 4 Proven Performance Hacks

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.

EasyExcelExcel importThread Pool

0 likes · 10 min read

Optimizing Large-Scale Excel Import/Export in Java with EasyExcel, Generics, and Thread Pools

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 ExportEasyExcelExcel import

0 likes · 14 min read

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

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.

Data ProcessingEasyExcelExcel import

0 likes · 13 min read

Optimizing Large-Scale Excel Import/Export in Java with EasyExcel and Thread Pools

JD Cloud Developers

Nov 20, 2024 · Backend Development

Designing Scalable Excel Import Pipelines: Four Architecture Patterns Compared

This article examines four architectural approaches for importing Excel data—synchronous, thread‑pooled with MQ, fully asynchronous with Redis locks, and an ideal high‑throughput variant—detailing their trade‑offs, performance impacts, and suitable business scenarios in modern backend systems.

Backend ArchitectureExcel importRedis Lock

0 likes · 10 min read

Designing Scalable Excel Import Pipelines: Four Architecture Patterns Compared

JD Tech Talk

Nov 20, 2024 · Backend Development

Design and Evaluation of Multiple Backend Excel Import Solutions for B2BTC Local Phase II

This article presents a detailed case study of four backend design alternatives for importing Excel data—ranging from synchronous processing to asynchronous pipelines with thread pools, message queues, and Redis locks—analyzing their advantages, drawbacks, and suitable scenarios.

Excel importRedisThread Pool

0 likes · 10 min read

Design and Evaluation of Multiple Backend Excel Import Solutions for B2BTC Local Phase II

Su San Talks Tech

Jun 30, 2024 · Backend Development

How to Ensure Transaction Rollback Across Asynchronous Threads in Spring

This article explains how to guarantee that when any asynchronous thread fails during a large Excel import, the main thread can roll back all related transactions, covering the limitations of @Transactional and @Async, thread‑local propagation, and practical solutions using Future, CompletableFuture, custom ForkJoinPool, and manual transaction management.

Asynchronous ProgrammingExcel importSpring

0 likes · 20 min read

How to Ensure Transaction Rollback Across Asynchronous Threads in Spring

Su San Talks Tech

Feb 13, 2024 · Backend Development

How to Ensure Transaction Consistency When Async Threads Fail in Spring

This article explains how to guarantee transactional integrity when importing a 100,000‑row Excel file with asynchronous threads in Spring, covering double‑async optimization, Future and CompletableFuture handling, @Transactional pitfalls, manual transaction control, and a complete solution for cross‑thread transaction management.

AsyncCompletableFutureExcel import

0 likes · 18 min read

How to Ensure Transaction Consistency When Async Threads Fail in Spring

Java High-Performance Architecture

Jul 12, 2023 · Backend Development

Master EasyExcel: Fast Java Excel Export/Import with Custom Merges

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

Master EasyExcel: Fast Java Excel Export/Import with Custom Merges

Selected Java Interview Questions

Jun 24, 2023 · Backend Development

Guide to Using EasyExcel in Java: Quick Start, Export/Import, and Custom Merge Strategies

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

Guide to Using EasyExcel in Java: Quick Start, Export/Import, and Custom Merge Strategies

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 exportExcel import

0 likes · 10 min read

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

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.

EasyExcelExcel importSpringBoot

0 likes · 18 min read

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

Java Architect Essentials

Aug 15, 2021 · Backend Development

Optimizing Large-Scale Excel Import Performance in Java Backend Applications

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.

Batch InsertEasyExcelExcel import

0 likes · 13 min read

Optimizing Large-Scale Excel Import Performance in Java Backend Applications

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 InsertEasyExcelExcel import

0 likes · 12 min read

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

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 exportExcel import

0 likes · 8 min read

EasyExcel Method Encapsulation for Simplified Excel Import and Export in Java

ITPUB

Jun 6, 2016 · Frontend Development

Batch Import Multiple Excel Files into FineReport with a Custom Button

This guide explains how to create a custom import button in FineReport that sequentially uploads multiple Excel files, automatically submits previous data, refreshes the page, and ensures the template remains empty for each new import.

Excel importFineReportcustom button

0 likes · 5 min read