Tagged articles
Apache POI
35 articles · Page 1 of 1
This article introduces FastExcel, a high-performance Java Excel library created by the original EasyExcel author, featuring streaming read/write, full API compatibility, new PDF conversion, and code examples for entity mapping, event listeners, and large-file processing.
Apache POIEasyExcelExcel processing
0 likes · 8 min read

This article introduces FastExcel, a high-performance Java library for Excel processing that succeeds EasyExcel, detailing its streaming API, entity mapping, read/write code examples, PDF conversion, and performance advantages over its predecessor.
Apache POIEasyExcelExcel processing
0 likes · 8 min read

This tutorial demonstrates using Apache POI 5.2.1 to create and read Excel .xlsx files in Java, covering Maven setup, cell styling, formula evaluation, date formatting, and fixing log4j2 logging errors with complete code examples.
Apache POIExcelFile I/O
0 likes · 14 min read

This tutorial demonstrates how to use JXLS 2.11.0 for complex Excel exports in Java, covering Maven setup, template creation with xlsx format, and key expressions like jx:area, jx:each, jx:mergeCells, and dynamic columns with code examples.
Apache POIDynamic ColumnsExcel Export
0 likes · 9 min read

The author describes how exporting 500k order records caused a 2GB heap OOM, then fixed it by replacing XSSFWorkbook with streaming SXSSFWorkbook, switching from full entity loading to cursor-based batch queries with DTOs, reusing cell styles, and finally decoupling large exports from HTTP requests via async task processing.
Apache POICursor PaginationExcel Export
0 likes · 14 min read

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

FileMagic validation throws IOException on real Excel uploads because Tomcat's default FileInputStream lacks mark/reset support, unlike test ByteArrayInputStream; wrapping with BufferedInputStream fixes it, and regression tests must simulate real stream types to catch this.
Apache POIBufferedInputStreamEasyExcel
0 likes · 8 min read

This tutorial demonstrates integrating Spring Boot with Poi-tl for dynamic Word document generation, covering template rendering, table row loops, image watermarks, dependency configuration, and production pitfalls like placeholder splitting and font issues.
Apache POIPoi-tlTable Loop
0 likes · 18 min read

This article explains how to prevent out‑of‑memory errors when importing huge Excel files in Java by using the open‑source excel‑streaming‑reader library, showing Maven setup, streaming code examples, memory‑saving configurations for shared strings and comments, and tips for handling extremely large workbooks.
Apache POIExcelJava
0 likes · 8 min read

This article walks through building a Spring Boot 3.5.0 service that uses Apache POI and XDocReport to load a DOCX file, extract images, convert it to HTML, and expose a controller endpoint for instant online preview without external plugins.
Apache POIJavaWord to HTML
0 likes · 7 min read

This guide explains how to reliably identify and remove existing watermarks from .xlsx files and then add new, precisely positioned semi‑transparent watermarks using Java's Apache POI library, complete with Maven setup, code examples, and performance tips.
Apache POIExcelFile Processing
0 likes · 10 min read

This tutorial demonstrates how to add Apache POI dependencies via Maven and use Java code to create an Excel workbook containing a multi‑series temperature line chart, including custom font sizes for titles and axes, and finally export the file to disk.
Apache POIExcelJava
0 likes · 8 min read

This article demonstrates how to create a generic utility that, through Java reflection and Apache POI, can export any list of objects—regardless of their class—into a CSV/Excel file, with optional custom column names via annotations.
Apache POIExportJava
0 likes · 11 min read

This article explains how to use Java libraries such as Apache POI, PDFBox, and EasyExcel to read Excel, DOC/DOCX, PDF, and plain text files, providing complete code examples, required Maven dependencies, and step‑by‑step usage instructions for each file type.
Apache POIFile I/OJava
0 likes · 13 min read

A Java developer recounts how an unexpected Excel export failure was traced to mismatched EasyPOI and Apache POI versions, the impact of Maven's -U flag, and the step‑by‑step resolution involving dependency alignment and careful version selection.
Apache POIDependency ConflictEasyPOI
0 likes · 11 min read

This tutorial demonstrates how to create a universal CSV/Excel export utility in Java that can handle objects of any class by using reflection to generate headers and rows, leveraging Apache POI and Spring Boot for seamless file generation.
Apache POICSVExcel
0 likes · 10 min read

The article explains why Apache POI loads entire .xlsx zip files into memory causing OOM, demonstrates the issue with code examples, and shows how switching to EasyExcel's streaming read dramatically reduces memory usage while handling large Excel files in Java.
Apache POIEasyExcelExcel
0 likes · 8 min read

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 POIExcel ExportJava
0 likes · 13 min read

This article explains how to overcome the limitations of traditional Apache POI when handling massive Excel import/export tasks by comparing POI workbook types, selecting the appropriate one, and using EasyExcel together with batch database queries and JDBC transactions to process up to three million rows efficiently.
Apache POIEasyExcelJDBC
0 likes · 23 min read

This article explains how to handle massive Excel import and export tasks in Java by comparing traditional POI implementations, selecting the appropriate Workbook type based on data volume, and leveraging Alibaba's EasyExcel library together with batch JDBC operations to process over three million rows with minimal memory usage and high performance.
Apache POIEasyExcelbig data
0 likes · 22 min read

This article walks through a real‑world OOM incident in an MQ consumer caused by large Excel import/export, explains how memory dumps and Prometheus logs pinpointed the culprit, and shows how switching from XSSFWorkbook to SXSSFWorkbook and tuning the thread pool resolved the issue.
Apache POIJavaOOM
0 likes · 9 min read

This article explains how to handle massive Excel import and export tasks in Java by comparing POI's HSSFWorkbook, XSSFWorkbook, and SXSSFWorkbook, selecting the right implementation, and using Alibaba's EasyExcel together with batch queries and JDBC batch inserts to process three million rows efficiently without memory overflow.
Apache POIEasyExcelJava
0 likes · 20 min read

This article analyzes why Apache POI runs out of memory when writing hundreds of thousands of rows to an Excel file, examines the underlying HSSFWorkbook implementation, and demonstrates how switching to the streaming SXSSFWorkbook API provides a stable, low‑memory solution for large‑scale Excel generation.
Apache POIExcelLargeData
0 likes · 6 min read

This tutorial demonstrates how to use Apache POI in Java to protect Excel sheets, unlock specific cells, adjust column widths and row heights, apply custom fonts and colors, and merge cells, providing complete code examples for each step.
Apache POICell ProtectionCell Style
0 likes · 8 min read

This article explains how to build a flexible Java utility for exporting large volumes of report data to Excel using Apache POI, covering customizable headers, field formatting, multithreaded data retrieval, asynchronous processing, and deployment steps.
Apache POIExcelJava
0 likes · 13 min read

This article introduces POI‑TL, a lightweight Java template engine built on Apache POI that lets developers generate Word documents with a single line of code, explains its core API, configuration options, rendering pipeline, and provides practical code examples for quick adoption.
Apache POIPoi-tlTemplate Engine
0 likes · 9 min read

This article explains how to create a reusable Java utility for Excel import and export using custom annotations, detailing the required EnableExport, EnableExportField, and ImportIndex annotations, the implementation of parsing and exporting methods with Apache POI, and providing sample code and usage examples.
AnnotationsApache POIExcel
0 likes · 8 min read

This article introduces Apache POI, the Java API for Microsoft Office documents, explains its core components such as Workbook, Sheet, Row, and Cell, and provides detailed code examples for creating, reading, and converting Java object lists to Excel files, including Maven dependencies and annotation usage.
AnnotationsApache POIExcel
0 likes · 11 min read

This article explains how to prevent frequent full GC and out‑of‑memory errors when using Apache POI for massive Excel imports and exports by leveraging SXSSFWorkbook for XLSX, choosing appropriate processing models for XLS/XLSX, and provides performance test results and code samples.
Apache POIExcelJava
0 likes · 18 min read

This article explains how to use EasyPOI for Excel template design, covering version compatibility, Maven configuration, template creation for simple and complex reports, expression syntax, image export pitfalls, and Java code examples to render data into templates without common pitfalls.
Apache POIEasyPOIExcel
0 likes · 15 min read

This article demonstrates how to use Apache POI in a Maven‑based Java project to read and write both XLS and XLSX Excel files, covering library setup, core APIs, data type handling, and practical import/export implementations with Spring MVC and MyBatis.
Apache POIExcelImportExport
0 likes · 19 min read

This article presents a Java utility that reads Excel files (both .xls and .xlsx) using Apache POI, extracts headers and numeric data into a nested List‑of‑Map structure, and includes error handling and type conversion details.
Apache POIExcelFile I/O
0 likes · 6 min read

This article presents a Java method that uses Apache POI to write data into XLSX files, detailing the implementation steps, code example, and practical considerations for generating test reports with Excel in automated testing environments.
Apache POIExcelFile I/O
0 likes · 3 min read

This article explains how a hotel finance team tackled multi‑source, high‑volume reconciliation challenges by creating a Java‑based, data‑driven automated testing platform using Maven, TestNG, and Apache POI, improving efficiency, accuracy, and maintainability while outlining the framework architecture and future enhancements.
Apache POIBackend testingJava
0 likes · 8 min read

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 POIExcel ExportJava
0 likes · 12 min read
