HSSF - is a pure Java Implementation of the Excel'97 2007 file format.
XSSF is the POI Project's pure Java implementation of the Excel 2007 OOXML - xlsx file format.
HSSF and XSSF provide ways to read spreadsheets
- create
- modify
- read
- write
Join model is HSSF and XSSF.
Reading an Excel
org.apache.poi.hssf.eventusermodel
org.apache.poi.xssf.eventusermodel
Use the usermodel api to modify the spreadsheet data.
You can also generate spreadsheets in the same way.
XSSF supports Excel 2007 OOXML (.xlsx) files are XML based, the memory footprint for processing them is higher than the older HSSF supported(.xls) binary files.
SXSSF
It is a low memory footprint by limiting access to the rows that are within a sliding window and written to disk. Window size can be set to grow dynamically; it can be trimmed periodically by an explicit call to flushRows(int keepRows).
It has a streaming nature of the implementation, there are the following limitations compared to XSSF
*Formula evaluation is not supported
* Sheet.clone() is not supported
*Only limited rows are accessible at a point in time.
XSSF is the POI Project's pure Java implementation of the Excel 2007 OOXML - xlsx file format.
HSSF and XSSF provide ways to read spreadsheets
- create
- modify
- read
- write
Join model is HSSF and XSSF.
Reading an Excel
org.apache.poi.hssf.eventusermodel
org.apache.poi.xssf.eventusermodel
Use the usermodel api to modify the spreadsheet data.
You can also generate spreadsheets in the same way.
XSSF supports Excel 2007 OOXML (.xlsx) files are XML based, the memory footprint for processing them is higher than the older HSSF supported(.xls) binary files.
SXSSF
It is a low memory footprint by limiting access to the rows that are within a sliding window and written to disk. Window size can be set to grow dynamically; it can be trimmed periodically by an explicit call to flushRows(int keepRows).
It has a streaming nature of the implementation, there are the following limitations compared to XSSF
*Formula evaluation is not supported
* Sheet.clone() is not supported
*Only limited rows are accessible at a point in time.
