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 :
The HSSF component is the most advanced feature of the library. Other components are usable, but less full-featured.
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
14. February 2020
20. October 2019
09. April 2019
07. September 2018
15. September 2017
19. April 2017
21. September 2016
2. March 2016
29. September 2015
11. May 2015
21. December 2014
18. August 2014
8. February 2014
3. December 2012
26. March 2012
29. October 2010
14. December 2009
28. September 2009
19. October 2008
29. June 2008
4. February 2008
5. July 2007
18. May 2007
29. February 2004
29. February 2004
26. January 2004
16. June 2002
6. May 2002
19. January 2002
4. January 2002
11. January 2002
4. January 2002
30. December 2001