Apache POI

Infobox Software
name = Apache POI



caption =
developer = Apache Software Foundation
latest release version = 3.1-FINAL
latest release date = release date|2008|06|29
latest preview version = 3.5 Beta 1
latest preview date = release date|2008|07|18
operating system = Cross-platform
programming language =
genre = API to access Microsoft Office formats
license = Apache License 2.0
website = http://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", [ [http://www.javaworld.com/javaworld/jw-03-2004/jw-0322-poi.html Excelling in Excel with Java] By Elango Sundaram, JavaWorld.com, 03/22/2004] referring humorously to the fact that the file formats seemed to be deliberately obfuscated, but poorly, since they were successfully reverse-engineered. This expansion – 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 humour appropriate. The authors also noted the existence of the Hawaiian poi dish, made of mashed taro root, which had similarly derogatory connotations. [ [http://web.archive.org/web/20041015142404/http://www.coyotesong.com/poi/ POI homepage from October 2004] , showing original explanations for naming]

Office Open XML support

Work is underway to support the Office Open XML file formats. The work is currently in an [http://svn.apache.org/viewvc/poi/branches/ooxml/ SVN branch] , and is expected to become POI 3.5. The targeted final release date is the summer 2008. [http://people.apache.org/~nick/POI-Talks/POI-FastFeatherTrack-ACEU08.odp POI OOXML/XSSF presentation at ApacheCon EU 2008]

This work remains controversial and tentative due to questions regarding Microsoft's Open Specification Promise patent license. [ [http://mail-archives.apache.org/mod_mbox/poi-dev/200803.mbox/[e-mail]%3e Mailing list archives ] ]

Architecture

The Apache POI project contains the following subcomponents:

* POIFS (Poor Obfuscation Implementation File System) – 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) – 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. For example, POI is unable to open spreadsheets that have filters or views Fact|date=March 2007.
* XSSF (XML SpreadSheet Format) – reads and writes Microsoft Excel OOXML (XLSX) format files – 3.5 branch only. Similar feature set to HSSF, but for Office Open XML files.
* HPSF (Horrible Property Set Format) – 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) – aims to read and write Microsoft Word 97 (DOC) format files. This component is in initial stages of development.
* HSLF (Horrible Slide Layout Format) – is 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)
* HDGF (Horrible DiaGram Format) – is an initial pure Java implementation for Microsoft Visio binary files. It provides an ability to read the low level contents of the files.

Currently (as of April, 2008), and apart from the base POIFS component, the HSSF component is the more advanced feature of the library. [ [http://poi.apache.org/hssf/index.html HSSF home page] at Apache.org] The other components (HPSF, HWPF, and HSLF) are in a working stage but still in early level of development. [ [http://poi.apache.org/hwpf/index.html HWPF home page] at Apache.org] [ [http://poi.apache.org/hslf/index.html HSLF home page] at Apache.org]

The POI library is also provided as a Ruby extension.

References

External links

* [http://poi.apache.org/ Apache POI] – the official Apache POI project page
* [http://oscon2006.sourceforge.net/ POI presentation at OSCON2006]