Using Apache POI and SXSSFWorkbook to Export Large Excel Files in Java

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.

BackendExcelSXSSFWorkbook

0 likes · 6 min read

Using Apache POI and SXSSFWorkbook to Export Large Excel Files in Java

Su San Talks Tech

Oct 10, 2022 · Backend Development

How a Massive Excel Import Triggered OOM in Our MQ Consumer—and the Fix

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 POIMemory analysisOOM

0 likes · 9 min read

How a Massive Excel Import Triggered OOM in Our MQ Consumer—and the Fix

Selected Java Interview Questions

Sep 4, 2022 · Backend Development

Resolving OutOfMemory Errors When Using Apache POI for Large Excel Exports

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

Resolving OutOfMemory Errors When Using Apache POI for Large Excel Exports