Apache POI Components for Excel Files

Q

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

✍: FYIcenter.com

A

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:
Apache POI Excel File API Features

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)

2017-03-17, 361👍, 0💬