HSSFWorkbook vs XSSFWorkbook vs SXSSFWorkbook - Apache-poi

java apache-poi xssf poi-hssf
Sedat Polat picture Sedat Polat · Oct 9, 2015 · Viewed 43.8k times · Source

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

Answer

nbokmans picture nbokmans · Oct 9, 2015

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

apifeatures

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

Related questions

Getting error "Your InputStream was neither an OLE2 stream, nor an OOXML stream" when created file through apache POI

I am trying to check if my excel file already exists. If it doesn't exists, I want to create a new one and if it exists I will delete it and create a new one. I wrote following program but …

Read More
Adding border to a merged region in POI XSSF workbook

I'm using apache poi 3.7 and I need to put border to a range of cells or merged region. how can I to apply border to a merged region when the sheet and workbook type is XSSF. In HSSF type I …

Read More
Apache POI error loading XSSFWorkbook class

I'm trying to write a program that works with Excel docs, but the HSSF format is too small for my requirements. I'm attempting to move to XSSF, but I keep getting errors when trying to use it. I managed to …

Read More