请输入您要查询的百科知识：

　

词条 Apache POI
释义

  1. History and roadmap

     Office Open XML support 

  2. Architecture

  3. Version history

  4. See also

  5. References

  6. External links

{{Infobox software
| name = Apache POI
| logo = Apache_POI_project_logo_(2018).svg
| screenshot =
| caption =
| developer = Apache Software Foundation
| latest release version = 4.0.0
| latest release date = {{release date and age|2018|09|07}}[1]
| latest preview version =
| latest preview date =
| programming language =
| operating system = Cross-platform
| genre = API to access Microsoft Office formats
| license = Apache License 2.0
| website = https://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)
  • 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{{cn|date=March 2019}}) – a pure Java implementation for Microsoft Publisher files.[8]
  • HSMF (Horrible Stupid Mail Format[9]) – a pure Java implementation for Microsoft Outlook MSG files.[10]
  • DDF (Dreadful Drawing Format[7]) – a package for decoding the Microsoft Office 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

{{Version|t|show=11101}}

Version number

Date of release
c |4.0.0}} 07. September 2018
co |3.17}} 15. September 2017
co |3.16}} 19. April 2017
co |3.15}} 21. September 2016
co |3.14}} 2. March 2016
co |3.13}} 29. September 2015
co |3.12}} 11. May 2015
co |3.11}} 21. December 2014
co |3.10.1}} 18. August 2014
o |3.10}} 8. February 2014
o |3.9}} 3. December 2012
o |3.8}} 26. March 2012
o |3.7}} 29. October 2010
o |3.6}} 14. December 2009
o |3.5}} 28. September 2009
o |3.2}} 19. October 2008
o |3.1}} 29. June 2008
o |3.0.2}} 4. February 2008
o |3.0.1}} 5. July 2007
o |3.0}} 18. May 2007
o |2.5.1}} 29. February 2004
o |2.5}} 29. February 2004
o |2.0}} 26. January 2004
o |1.5.1}} 16. June 2002
o |1.5}} 6. May 2002
o |1.2.0}} 19. January 2002
o |1.1.0}} 4. January 2002
o |1.0.2}} 11. January 2002
o |1.0.1}} 4. January 2002
o |1.0.0}} 30. December 2001

See also

  • Open Packaging Conventions
  • Office Open XML software

References

1. ^{{cite web |url=https://poi.apache.org/changes.html |title=[ANNOUNCE] Apache POI 4.0.0 released |date=2018-09-07 |accessdate=2018-09-13}}
2. ^1 2 3 {{citation | url = http://www.javaworld.com/javaworld/jw-03-2004/jw-0322-poi.html | title = Excelling in Excel with Java | first = Elango | last = Sundaram | publisher = Java World | date = 2004-03-22}}
3. ^{{citation | url = http://www.coyotesong.com/poi/ | archiveurl = https://web.archive.org/web/20041015142404/http://www.coyotesong.com/poi/ | archivedate = 2004-10-15 | title = POI homepage from October 2004 | publisher = Coyote Song}}, showing original explanations for naming.
4. ^{{citation | url = http://www.sourcesense.com/ | title = SourceSense}}
5. ^{{cite web| url=http://www.informationweek.com/news/windows/showArticle.jhtml?articleID=206905858| title= Microsoft Eyes Open Source Components for Office 2007| publisher= Information Week| date=26 March 2008| accessdate=1 March 2009}}
6. ^{{citation | url = http://mail-archives.apache.org/mod_mbox/poi-dev/200803.mbox/%3c47EAE71C.6040603@buni.org%3e | title = POI development mailing list archives | date = March 2008}}
7. ^1 2 3 4 {{cite web|url=https://poi.apache.org/apidocs/dev/ |title=POI API Documentation |publisher=Poi.apache.org |date= |accessdate=2019-03-07}}
8. ^{{cite web|url=https://poi.apache.org/components/hpbf/index.html |title=POI-HPBF - Java API To Access Microsoft Publisher Format Files |publisher=Poi.apache.org |date= |accessdate=2019-03-07}}
9. ^{{citation | url = http://npoi.codeplex.com/discussions/233518 | publisher = Microsoft | title = Codeplex NPOI|archiveurl=https://web.archive.org/web/20120328092553/http://npoi.codeplex.com/discussions/233518|archivedate=2012-03-28}}{{Better source|date=January 2012|reason=CIRCULAR, as ref in source is this article}}
10. ^{{citation | title = POI-HSMF | publisher = Apache | url = http://poi.apache.org/hsmf/ | access-date = 2011-07-31 | archive-url = https://web.archive.org/web/20110807211225/http://poi.apache.org/hsmf/ | archive-date = 2011-08-07 | dead-url = yes | df = }}
11. ^{{citation | url = http://poi.apache.org/hssf/ | title = POI-HSSF | publisher = Apache}}
12. ^{{citation | url = http://poi.apache.org/hwpf/ | title = POI-HWPF | publisher = Apache}}
13. ^{{citation | url = http://poi.apache.org/hslf/ | title = POI-HSLF | publisher = Apache}}
14. ^{{citation | title = POI-Ruby | publisher = Apache | url = http://poi.apache.org/poi-ruby.html}}
15. ^{{cite web|url=https://github.com/ZuInnoTe/hadoopoffice/wiki |title=HadoopOffice for Hive/Flink/Spark |publisher=Github.com |date=2018-07-19 |accessdate=2019-03-07}}
16. ^{{cite web|url=https://github.com/crealytics/spark-excel |title=Spark Excel |publisher=Github.com |date= |accessdate=2019-03-07}}

External links

  • {{Official website}}
{{Apache}}{{DEFAULTSORT:Apache Poi}}

5 : Apache Software Foundation|Microsoft Office-related software|Java platform|Java (programming language) libraries|Cross-platform free software
随便看

　

开放百科全书收录14589846条英语、德语、日语等多语种百科知识，基本涵盖了大多数领域的百科知识，是一部内容自由、开放的电子版国际百科全书。

　

Copyright © 2023 OENC.NET All Rights Reserved
京ICP备2021023879号 更新时间：2024/9/24 5:32:50