HSSFWorkbook vs XSSFWorkbook vs SXSSFWorkbook - Apache-poi

Question

HSSFWorkbook vs XSSFWorkbook and the advantages/disadvantages of XSSFWorkbook and SXSSFWorkbook?

Solution

A spreadsheet of each with as a summary of API features:

Source: https://poi.apache.org/spreadsheet/

Comments

[Gagravarr]

Which file format are you trying to support, and how big are you files? Those'll make the biggest differences to which you want!

[Sedat Polat]

@Gagravarr, This question is for giving general information about WorkBook of Apache-Poi, because I saw that people don't know which one is suitable for their requirement.

[Sedat Polat]

"SXSSF is an API-compatible streaming extension of XSSF to be used when very large spreadsheets have to be produced, and heap space is limited. SXSSF achieves its low memory footprint by limiting access to the rows that are within a sliding window, while XSSF gives access to all rows in the document. Older rows that are no longer in the window become inaccessible, as they are written to the disk. "

[martian]

poi.apache.org/spreadsheet/eval.html For versions before 3.13 final, no formula evaluation is possible with SXSSF. If you are using POI 3.13 final or newer, formula evaluation is possible with SXSSF, but with some caveats.

[Sachin Sharma]

is there a comparison of memory footprints available (for various file sizes)?