BestHub
Sign in
Tagged articles

SXSSFWorkbook

4 articles · Page 1 of 1
LuTiao Programming
LuTiao Programming
Sep 30, 2026 · Backend Development

Spring Boot Excel Export OOM: Replacing XSSFWorkbook with SXSSFWorkbook and Batch Processing

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 POIAsync ProcessingBatch Processing
0 likes · 14 min read
Spring Boot Excel Export OOM: Replacing XSSFWorkbook with SXSSFWorkbook and Batch Processing
Su San Talks Tech
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 POIJavaMemory Analysis
0 likes · 9 min read
How a Massive Excel Import Triggered OOM in Our MQ Consumer—and the Fix