What are Apache POI components that can be used to read and write Microsoft Excel files?

There are 3 components in the Apache POI Java library that can be used to read and write Microsoft Excel spreadsheet files:

• HSSF (Horrible Spreadsheet Format) component provides API to read and write older versions of Microsoft Excel files (*.xls)
• XSSF (OpenXML SpreadSheet Format) component - provides API to read and write newer versions of Microsoft Excel files (*.xlsx)
• SXSSF (Streaming OpenXML SpreadSheet Format) component - provides API to read and write newer versions of Microsoft Excel files (*.xlsx) with streaming buffers.

The picture below gives a summary of features supported by each Apache POI Excel file components:

For more information, see Apache POI-HSSF and POI-XSSF - Java API To Access Microsoft Excel Format Files Web page.

⇒Apache POI Examples for Excel Files

⇒⇒FAQ for Apache POI (Poor Obfuscation Implementation)