BestHub
Sign in
Tag

SXSSFWorkbook

1 views collected around this technical thread.

Selected Java Interview Questions
Selected Java Interview Questions
Feb 14, 2023 · Backend Development

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.

Apache POIBackendChatGPT
0 likes · 6 min read
Using Apache POI and SXSSFWorkbook to Export Large Excel Files in Java
Selected Java Interview Questions
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 POIBackendJava
0 likes · 6 min read
Resolving OutOfMemory Errors When Using Apache POI for Large Excel Exports