Tagged articles
excel-import
24 articles · Page 1 of 1
The article details refactoring a synchronous Spring Boot Excel import that failed at 100k rows into an async task model with streaming Apache POI SAX parsing, 500-row JDBC batch inserts, row-level error isolation, and SSE real-time progress, eliminating 504 timeouts and duplicate data on retry.
Apache POIAsynchronous ProcessingSSE
0 likes · 18 min read

This article details a production-ready engineering approach for importing hundreds of thousands of Excel rows using Spring Boot and EasyExcel, covering streaming parsing, batch validation, async task isolation, idempotency, error reporting, and operational concerns like logging and temp file cleanup.
EasyExcelIdempotencyProduction Engineering
0 likes · 23 min read

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

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

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

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.
EasyExcelExcel ExportJava
0 likes · 11 min read

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

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.
BackendEasyExcelcustom-listener
0 likes · 10 min read

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.
BackendJavaSpring
0 likes · 10 min read

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.
EasyExcelGenericsJava
0 likes · 10 min read

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.
EasyExcelSpring Bootdata export
0 likes · 14 min read

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.
EasyExcelJavadata processing
0 likes · 13 min read

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.
Asynchronous ProcessingRedis Lockbackend architecture
0 likes · 10 min read

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.
Asynchronous ProcessingRedisbackend design
0 likes · 10 min read

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 ProgrammingJavaSpring
0 likes · 20 min read

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.
AsyncCompletableFutureFuture
0 likes · 18 min read

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

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

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

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.
EasyExcelJavaSpringBoot
0 likes · 18 min read

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.
EasyExcelJavaMySQL
0 likes · 13 min read

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.
EasyExcelJavaMyBatis
0 likes · 12 min read

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


ITPUBJun 6, 2016 · Frontend Development
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.
FineReportcustom buttondata entry
0 likes · 5 min read
