Skip to content
Tagged articles

EasyExcel

107 articles · Page 2 of 2
Selected Java Interview Questions
Selected Java Interview Questions
Jan 17, 2021 · Backend Development

Lombok Getter/Setter Pitfalls with MyBatis and @Accessor(chain=true) Issues in EasyExcel

This article explains why Lombok-generated getter/setter methods for fields whose second character is uppercase can cause MyBatis to store null values, shows the MyBatis PropertyNamer logic that leads to the problem, and also describes how the @Accessor(chain=true) annotation interferes with EasyExcel's reflection‑based export, offering practical workarounds for both issues.

EasyExcelGetterSetterJava
0 likes · 9 min read
Lombok Getter/Setter Pitfalls with MyBatis and @Accessor(chain=true) Issues in EasyExcel
Architecture Digest
Architecture Digest
Jan 6, 2021 · Backend Development

Optimizing Large-Scale Excel Import Performance in Java Backend Applications

This article details a step‑by‑step optimization of a Java backend Excel import pipeline, covering data validation caching, batch insertion with MySQL VALUES, switching to EasyExcel, parallel stream insertion, and logging reduction to achieve sub‑minute import times for hundreds of thousands of rows.

EasyExcelExcelJava
0 likes · 11 min read
Optimizing Large-Scale Excel Import Performance in Java Backend Applications
Architecture Digest
Architecture Digest
Sep 15, 2020 · Databases

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

This article details how to dramatically speed up Excel‑driven fee‑record imports by replacing naïve POI row‑by‑row processing with EasyExcel, caching database look‑ups, using MySQL batch INSERTs, and finally applying parallel streams for multi‑threaded insertion, while also trimming excessive logging.

EasyExcelExcelJava
0 likes · 12 min read
Optimizing Large‑Scale Excel Import in Java: From POI to EasyExcel, Caching, Batch Inserts and Parallel Processing
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
Programmer DD
Programmer DD
Nov 4, 2019 · Backend Development

Master Efficient Excel Imports in Java with EasyExcel and Spring Boot

This article explains how Java backend developers can replace memory‑heavy Apache POI with EasyExcel for fast, low‑memory Excel imports, covering basic reading, custom converters for gender and dates, and multiple Spring Boot integration patterns including controllers, listeners, constructor injection and lambda‑based approaches.

EasyExcelExcelJava
0 likes · 12 min read
Master Efficient Excel Imports in Java with EasyExcel and Spring Boot
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