Apache POI

Apache POI

Developer(s)	Apache Software Foundation
Stable release	5.3.0 / July 2, 2024;7 months ago (2024-07-02) [1]
Repository	POI Repository
Written in	Java
Operating system	Cross-platform
Type	API to access Microsoft Office formats
License	Apache License 2.0
Website	poi.apache.org

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", ^[2] 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 (Andrew C. Oliver and Marc Johnson) also noted the existence of the Hawaiian poi dish, made of mashed taro root, which had similarly derogatory connotations. ^[3]

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, ^[4] an open source company which was commissioned by Microsoft to develop this contribution. ^[5] This link spurred controversy, some POI contributors questioning POI OOXML patent protection regarding Microsoft's Open Specification Promise patent license. ^[6]

Architecture

The Apache POI project contains the following subcomponents (meaning of acronyms is taken from old documentation):

• POIFS (Poor Obfuscation Implementation File System ^[2] ) – 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 (Horrible SpreadSheet Format ^[2] ) – reads and writes Microsoft Excel (XLS) 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 (XML SpreadSheet Format) – reads and writes Office Open XML (XLSX) format files. Similar feature set to HSSF, but for Office Open XML files.
• HPSF (Horrible Property Set Format ^[2] ) – 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 (Horrible Word Processor Format ^[7] ) – aims to read and write Microsoft Word 97 (DOC) format files. This component is in initial stages of development.
• XWPF (XML Word Processor Format ^[7] ) – similar feature set to HWPF, but for Office Open XML files.
• HSLF (Horrible Slide Layout Format ^[7] ) – a pure Java implementation for Microsoft PowerPoint files. This provides the ability to read, create and edit presentations (though some things are easier to do than others)
• XSLF (Open Office XML Slideshow Format)
• HDGF (Horrible DiaGram Format ^[7] ) – an initial pure Java implementation for Microsoft Visio binary files. It provides an ability to read the low level contents of the files.
• HPBF (Horrible PuBlisher Format^{[ citation needed ]}) – a pure Java implementation for Microsoft Publisher files. ^[8]
• HSMF (Horrible Stupid Mail Format ^{[9] [ better source needed ]}) – a pure Java implementation for Microsoft Outlook MSG files. ^[10]
• DDF (Dreadful Drawing Format ^[7] ) – a package for decoding the Microsoft Office Drawing format.
• XDDF (XML Dreadful Drawing Format)

The HSSF component is the most advanced feature of the library. ^[11] Other components (HPSF, HWPF, and HSLF) are usable, but less full-featured. ^{[12] [13]}

The POI library is also provided as a Ruby ^[14] or ColdFusion extension.

There are modules for Big Data platforms (e.g. Apache Hive/Apache Flink/Apache Spark), which provide certain functionality of Apache POI, such as the processing of Excel files. ^{[15] [16]}

Version history

Legend:

Old version, not maintained

Old version, still maintained

Latest version

Latest preview version

Future version

Version number	Date of release
class="templateVersion c swatch-latest" style="color: var(--color-base, #202122); " title="Latest version" data-sort-value="5.3.0" | Latest version:5.3.0	July 2, 2024
class="templateVersion co swatch-unsupported" style="color: var(--color-base, #202122); " title="Old version, not maintained" data-sort-value="5.2.0" | Old version, not maintained: 5.2.0	January 14, 2022
class="templateVersion co swatch-unsupported" style="color: var(--color-base, #202122); " title="Old version, not maintained" data-sort-value="5.1.0" | Old version, not maintained: 5.1.0	November 1, 2021
class="templateVersion co swatch-unsupported" style="color: var(--color-base, #202122); " title="Old version, not maintained" data-sort-value="5.0.0" | Old version, not maintained: 5.0.0	January 20, 2021
class="templateVersion co swatch-unsupported" style="color: var(--color-base, #202122); " title="Old version, not maintained" data-sort-value="4.1.0" | Old version, not maintained: 4.1.0	April 9, 2019
class="templateVersion co swatch-unsupported" style="color: var(--color-base, #202122); " title="Old version, not maintained" data-sort-value="4.0.0" | Old version, not maintained: 4.0.0	September 7, 2018
class="templateVersion co swatch-unsupported" style="color: var(--color-base, #202122); " title="Old version, not maintained" data-sort-value="3.17" | Old version, not maintained: 3.17	September 15, 2017
class="templateVersion co swatch-unsupported" style="color: var(--color-base, #202122); " title="Old version, not maintained" data-sort-value="3.16" | Old version, not maintained: 3.16	April 19, 2017
class="templateVersion co swatch-unsupported" style="color: var(--color-base, #202122); " title="Old version, not maintained" data-sort-value="3.15" | Old version, not maintained: 3.15	September 21, 2016
class="templateVersion co swatch-unsupported" style="color: var(--color-base, #202122); " title="Old version, not maintained" data-sort-value="3.14" | Old version, not maintained: 3.14	March 2, 2016
class="templateVersion co swatch-unsupported" style="color: var(--color-base, #202122); " title="Old version, not maintained" data-sort-value="3.13" | Old version, not maintained: 3.13	September 29, 2015
class="templateVersion co swatch-unsupported" style="color: var(--color-base, #202122); " title="Old version, not maintained" data-sort-value="3.12" | Old version, not maintained: 3.12	May 11, 2015
class="templateVersion co swatch-unsupported" style="color: var(--color-base, #202122); " title="Old version, not maintained" data-sort-value="3.11" | Old version, not maintained: 3.11	December 21, 2014
class="templateVersion co swatch-unsupported" style="color: var(--color-base, #202122); " title="Old version, not maintained" data-sort-value="3.10" | Old version, not maintained: 3.10	February 8, 2014
class="templateVersion co swatch-unsupported" style="color: var(--color-base, #202122); " title="Old version, not maintained" data-sort-value="3.9" | Old version, not maintained: 3.9	December 3, 2012
class="templateVersion co swatch-unsupported" style="color: var(--color-base, #202122); " title="Old version, not maintained" data-sort-value="3.8" | Old version, not maintained: 3.8	March 26, 2012
class="templateVersion co swatch-unsupported" style="color: var(--color-base, #202122); " title="Old version, not maintained" data-sort-value="3.7" | Old version, not maintained: 3.7	October 29, 2010
class="templateVersion co swatch-unsupported" style="color: var(--color-base, #202122); " title="Old version, not maintained" data-sort-value="3.6" | Old version, not maintained: 3.6	December 14, 2009
class="templateVersion co swatch-unsupported" style="color: var(--color-base, #202122); " title="Old version, not maintained" data-sort-value="3.5" | Old version, not maintained: 3.5	September 28, 2009
class="templateVersion co swatch-unsupported" style="color: var(--color-base, #202122); " title="Old version, not maintained" data-sort-value="3.2" | Old version, not maintained: 3.2	October 19, 2008
class="templateVersion co swatch-unsupported" style="color: var(--color-base, #202122); " title="Old version, not maintained" data-sort-value="3.1" | Old version, not maintained: 3.1	June 29, 2008
class="templateVersion co swatch-unsupported" style="color: var(--color-base, #202122); " title="Old version, not maintained" data-sort-value="3.0" | Old version, not maintained: 3.0	May 18, 2007
class="templateVersion co swatch-unsupported" style="color: var(--color-base, #202122); " title="Old version, not maintained" data-sort-value="2.5" | Old version, not maintained: 2.5	February 29, 2004
class="templateVersion co swatch-unsupported" style="color: var(--color-base, #202122); " title="Old version, not maintained" data-sort-value="2.0" | Old version, not maintained: 2.0	January 26, 2004
class="templateVersion co swatch-unsupported" style="color: var(--color-base, #202122); " title="Old version, not maintained" data-sort-value="1.5" | Old version, not maintained: 1.5	May 6, 2002
class="templateVersion co swatch-unsupported" style="color: var(--color-base, #202122); " title="Old version, not maintained" data-sort-value="1.2.0" | Old version, not maintained: 1.2.0	January 19, 2002
class="templateVersion co swatch-unsupported" style="color: var(--color-base, #202122); " title="Old version, not maintained" data-sort-value="1.1.0" | Old version, not maintained: 1.1.0	January 4, 2002
class="templateVersion co swatch-unsupported" style="color: var(--color-base, #202122); " title="Old version, not maintained" data-sort-value="1.0.0" | Old version, not maintained: 1.0.0	December 30, 2001

See also

• Open Packaging Conventions
• Office Open XML software

References

1. "History of Changes" . Retrieved October 28, 2024.
2. Sundaram, Elango (22 March 2004), "Excelling in Excel with Java", JavaWorld , retrieved 2020-07-21
3. POI homepage from October 2004, Coyote Song, archived from the original on October 15, 2004, showing original explanations for naming.
4. SourceSense
5. McDougall, Paul (26 March 2008). "Microsoft Eyes Open Source Components for Office 2007". InformationWeek . Retrieved 2020-07-21.
6. Oliver, Andrew C. (27 March 2008), "Rejection of any ENCUMBERED Microsoft Donation to POI", POI development mailing list archives, retrieved 2020-07-21
7. "POI API Documentation". Poi.apache.org. Retrieved March 7, 2019.
8. "POI-HPBF - Java API To Access Microsoft Publisher Format Files". Poi.apache.org. Retrieved March 7, 2019.
9. Codeplex NPOI, Microsoft, archived from the original on March 28, 2012
10. POI-HSMF, Apache, archived from the original on August 7, 2011, retrieved July 31, 2011
11. POI-HSSF, Apache
12. POI-HWPF, Apache
13. POI-HSLF, Apache
14. POI-Ruby, Apache
15. "HadoopOffice for Hive/Flink/Spark". Github.com. July 19, 2018. Retrieved March 7, 2019.
16. "Spark Excel". Github.com. Retrieved March 7, 2019.

External links

• Official website