Apache POI
Apache POI, a project run by the Apache Software Foundation, and previously a sub-project of the Jakarta Project, provides pure Java libraries for reading and writing files in Microsoft Office formats, such as Word, PowerPoint and Excel.
History and roadmap
The name was originally an acronym for "Poor Obfuscation Implementation", referring humorously to the fact that the file formats seemed to be deliberately obfuscated, but poorly, since they were successfully reverse-engineered. This explanation – and those of the similar names for the various sub-projects – were removed from the official web pages in order to better market the tools to businesses who would not consider such humor appropriate. The original authors also noted the existence of the Hawaiian poi dish, made of mashed taro root, which had similarly derogatory connotations.Office Open XML support
POI supports the ISO/IEC 29500:2008 Office Open XML file formats since version 3.5. A significant contribution for OOXML support came from Sourcesense, an open source company which was commissioned by Microsoft to develop this contribution. This link spurred controversy, some POI contributors questioning POI OOXML patent protection regarding Microsoft's Open Specification Promise patent license.Architecture
The Apache POI project contains the following subcomponents :- POIFS – This component reads and writes Microsoft's OLE 2 Compound document format. Since all Microsoft Office files are OLE 2 files, this component is the basic building block of all the other POI elements. POIFS can therefore be used to read a wider variety of files, beyond those whose explicit decoders are already written in POI.
- HSSF – reads and writes Microsoft Excel format files. It can read files written by Excel 97 onwards; this file format is known as the BIFF 8 format. As the Excel file format is complex and contains a number of tricky characteristics, some of the more advanced features cannot be read.
- XSSF – reads and writes Office Open XML format files. Similar feature set to HSSF, but for Office Open XML files.
- HPSF – reads "Document Summary" information from Microsoft Office files. This is essentially the information that one can see by using the File|Properties menu item within an Office application.
- HWPF – aims to read and write Microsoft Word 97 format files. This component is in initial stages of development.
- XWPF – similar feature set to HWPF, but for Office Open XML files.
- HSLF – a pure Java implementation for Microsoft PowerPoint files. This provides the ability to read, create and edit presentations
- XSLF
- HDGF – an initial pure Java implementation for Microsoft Visio binary files. It provides an ability to read the low level contents of the files.
- HPBF – a pure Java implementation for Microsoft Publisher files.
- HSMF – a pure Java implementation for Microsoft Outlook MSG files.
- DDF – a package for decoding the Microsoft Office Drawing format.
- XDDF
The POI library is also provided as a Ruby or ColdFusion extension.
There are modules for Big Data platforms, which provide certain functionality of Apache POI, such as the processing of Excel files.
Version history
| Version number | Date of release |