1 views collected around this technical thread.
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.
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 demonstrates how to use Apache POI's XSSFWorkbook and SXSSFWorkbook classes in Java to export data to Excel files, addresses memory overflow issues with large datasets, shows code examples, and discusses the role of ChatGPT in assisting programmers without replacing them.
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 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 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 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 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.