Excel import | BestHub

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.

Backend DevelopmentEasyExcelExcel import

0 likes · 10 min read

Optimizing Large-Scale Excel Import/Export in Java with EasyExcel, Generics, 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 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 importMessage QueueRedis

0 likes · 10 min read

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

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.

Backend DevelopmentCustom MergeEasyExcel

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 importJava

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.

EasyExcelExcel importJava

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.

EasyExcelExcel importJava

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