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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
