Apache POI
| Apache POI
|
|
|---|---|
.svg){kind=logo}
|
|
| Basic data
|
|
| developer | Apache Software Foundation |
| Publishing year | January 26, 2006 |
| Current version |
4.1.2 ( February 17, 2020 ) |
| operating system | cross-platform |
| programming language | Java |
| License | Apache license, version 2.0 |
| poi.apache.org | |
POI is a free Java - program library for reading and writing files in the file format of Microsoft Office such. B. Word and Excel . The software started as part of the Jakarta project and is now an Apache top-level project.
The name was originally an acronym for "Poor Obfuscation Implementation".
The Apache POI project contains the following sub-components:
- POIFS (Poor Obfuscation Implementation File System): This component reads and writes files in Microsoft's OLE-2 compound document format. The OLE-2 Compound Document Format is a file system in which the data of a Microsoft Office document is stored in the form of files. The word obfuscation alludes to the fact that this filesystem is somewhat obfuscated.
- HSSF (Horrible Spreadsheet Format) and XSSF: This component reads and writes files in Excel format (Excel-97, Excel-XP, Excel-2003, Excel-2007, Excel-2008).
- HPSF (Horrible Property Set Format): This component reads and writes information about the document properties of a file in Microsoft Office format (»File → Properties«).
- HWPF (Horrible Word Processor Format) and XWPF: This component reads and writes files in Word format (Word-97, Word-XP, Word-2003, Word-2007). The component is located in the scratchpad (see below).
- HSLF (Horrible Slide Format) and XSLF: This component reads and writes files in Powerpoint format ( Powerpoint -97, Powerpoint-XP, Powerpoint-2003). It is located in the scratchpad (see below).
- HDGF (Horrible DiaGram Format): This component reads files in Visio format (Visio-97, Visio-XP, Visio-2003, Visio-2007). It is not possible to write to the files. The component is located in the scratchpad (see below).
- HPBF (Horrible PuBlisher Format): This component reads files in Publisher format. The component is located in the scratchpad (see below).
- HSMF (Horrible Stupid Mail Format): Reads files in Outlook format.
There are external modules for big data platforms (e.g. Apache Hive / Apache Flink / Apache Spark) which provide certain functions of Apache POI, such as the processing of Excel files.
Version history
| Legend: | Older version; no longer supported | Older version; still supported | Current version | Future version |
|---|
|
Version number |
Release date |
|---|---|
| 4.1.2 | 17th February 2020 |
| 4.1.1 | 20th October 2019 |
| 4.1.0 | April 9, 2019 |
| 4.0.1 | 3rd December 2018 |
| 4.0.0 | September 7, 2018 |
| 3.17 | 15th September 2017 |
| 3.16 | 19th April 2017 |
| 3.15 | September 21, 2016 |
| 3.14 | March 7, 2016 |
| 3.13 | 29th September 2015 |
| 3.12 | May 11, 2015 |
| 3.11 | December 21, 2014 |
| 3.10.1 | August 18, 2014 |
| 3.10 | February 8, 2014 |
| 3.9 | 3rd December 2012 |
| 3.8 | March 26, 2012 |
| 3.7 | October 29, 2010 |
| 3.6 | December 14, 2009 |
| 3.5 | September 28, 2009 |
| 3.2 | October 19, 2008 |
| 3.1 | June 29, 2008 |
| 3.0.2 | February 4, 2008 |
| 3.0.1 | July 5, 2007 |
| 3.0 | May 18, 2007 |
| 2.5.1 | February 29, 2004 |
| 2.5 | February 29, 2004 |
| 2.0 | January 26, 2004 |
| 1.5.1 | June 16, 2002 |
| 1.5 | May 6, 2002 |
| 1.2.0 | January 19, 2002 |
| 1.1.0 | January 4, 2002 |
| 1.0.2 | January 11, 2002 |
| 1.0.1 | January 4, 2002 |
| 1.0.0 | December 30, 2001 |
The POI developer version is a Java - source code in a subversion repository.
Scratchpad
Not all POI components are yet in a state that POI developers consider to be fully developed. These components can undergo major changes in the further development. To make this clear to the users, they are located in the so-called scratchpad, an area that is intended as a playground and for immature things.
Web links
- Official website
- Developer version source code
- OpenOffice.org Spreadsheet Project
- NPOI - an offshoot project for .NET
Individual evidence
- ↑ projects.apache.org . (accessed on April 8, 2020).
- ^ History of Changes . (English, accessed March 7, 2020).
- ^ The poi Open Source Project on Open Hub: Languages Page . In: Open Hub . (accessed on September 26, 2018).
- ↑ projects.apache.org . In: Open Hub . (accessed on April 8, 2020).
- ↑ HadoopOffice for Hive / Flink / Spark
- ↑ Spark Excel