| Developer(s) | Apache Software Foundation |
|---|---|
| Stable release | |
| Repository | POI Repository |
| Written in | Java |
| Operating system | Cross-platform |
| Type | API to access Microsoft Officeformats |
| 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 Officeformats, such as Word, PowerPoint and Excel.
History and roadmap[edit]
The XLS file type has been the default Excel file extension and format before Excel 2007. In Excel 2007, XLSX replaced the XLS format. Therefore, XLS is kind of outdated right now. In the daily life you won't find it often any more. But some data base tools still export data as XLS files.
Looking for the definition of XLSX? Find out what is the full meaning of XLSX on Abbreviations.com! 'Excel Microsoft Office Open XML Format Spreadsheet file' is one option - get in to view more @ The Web's largest and most authoritative acronyms and abbreviations resource. XLS and XLSX files. XLSX and XLS files are Microsoft Excel Spreadsheets commonly used to store financial data and to create mathematical models. These files store data in worksheets that contain cells arranged as a grid of rows and columns. Excel spreadsheets may also contain charts, mathematical functions, and various kinds of cell formatting.
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[edit]
Secure ftp client. 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[edit]
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 2Compound 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[citation needed]) – 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[edit]
| Legend: | Old version, not maintained | Older version, still maintained | Current stable version | Latest preview version | Future release |
|---|
Version number | Date of release |
|---|---|
| Current stable version:4.1.2 | 14. February 2020 |
| Old version, no longer maintained: 4.1.1 | 20. October 2019 |
| Old version, no longer maintained: 4.1.0 | 09. April 2019 |
| Old version, no longer maintained: 4.0.0 | 07. September 2018 |
| Old version, no longer maintained: 3.17 | 15. September 2017 |
| Old version, no longer maintained: 3.16 | 19. April 2017 |
| Old version, no longer maintained: 3.15 | 21. September 2016 |
| Old version, no longer maintained: 3.14 | 2. March 2016 |
| Old version, no longer maintained: 3.13 | 29. September 2015 |
| Old version, no longer maintained: 3.12 | 11. May 2015 |
| Old version, no longer maintained: 3.11 | 21. December 2014 |
| Old version, no longer maintained: 3.10.1 | 18. August 2014 |
| Old version, no longer maintained: 3.10 | 8. February 2014 |
| Old version, no longer maintained: 3.9 | 3. December 2012 |
| Old version, no longer maintained: 3.8 | 26. March 2012 |
| Old version, no longer maintained: 3.7 | 29. October 2010 |
| Old version, no longer maintained: 3.6 | 14. December 2009 |
| Old version, no longer maintained: 3.5 | 28. September 2009 |
| Old version, no longer maintained: 3.2 | 19. October 2008 |
| Old version, no longer maintained: 3.1 | 29. June 2008 |
| Old version, no longer maintained: 3.0.2 | 4. February 2008 |
| Old version, no longer maintained: 3.0.1 | 5. July 2007 |
| Old version, no longer maintained: 3.0 | 18. May 2007 |
| Old version, no longer maintained: 2.5.1 | 29. February 2004 |
| Old version, no longer maintained: 2.5 | 29. February 2004 |
| Old version, no longer maintained: 2.0 | 26. January 2004 |
| Old version, no longer maintained: 1.5.1 | 16. June 2002 |
| Old version, no longer maintained: 1.5 | 6. May 2002 |
| Old version, no longer maintained: 1.2.0 | 19. January 2002 |
| Old version, no longer maintained: 1.1.0 | 4. January 2002 |
| Old version, no longer maintained: 1.0.2 | 11. January 2002 |
| Old version, no longer maintained: 1.0.1 | 4. January 2002 |
| Old version, no longer maintained: 1.0.0 | 30. December 2001 |
See also[edit]
References[edit]
- ^'History of Changes'. 2020-02-14. Retrieved 2020-02-15.
- ^ abcdSundaram, Elango (22 March 2004), 'Excelling in Excel with Java', JavaWorld, retrieved 2020-07-21
- ^POI homepage from October 2004, Coyote Song, archived from the original on 2004-10-15, showing original explanations for naming.
- ^SourceSense
- ^McDougall, Paul (26 March 2008). 'Microsoft Eyes Open Source Components for Office 2007'. InformationWeek. Retrieved 2020-07-21.
- ^Oliver, Andrew C. (27 March 2008), 'Rejection of any ENCUMBERED Microsoft Donation to POI', POI development mailing list archives, retrieved 2020-07-21
- ^ abcde'POI API Documentation'. Poi.apache.org. Retrieved 2019-03-07.
- ^'POI-HPBF - Java API To Access Microsoft Publisher Format Files'. Poi.apache.org. Retrieved 2019-03-07.
- ^Codeplex NPOI, Microsoft, archived from the original on 2012-03-28[better source needed]
- ^POI-HSMF, Apache, archived from the original on 2011-08-07, retrieved 2011-07-31
- ^POI-HSSF, Apache
- ^POI-HWPF, Apache
- ^POI-HSLF, Apache
- ^POI-Ruby, Apache
- ^'HadoopOffice for Hive/Flink/Spark'. Github.com. 2018-07-19. Retrieved 2019-03-07.
- ^'Spark Excel'. Github.com. Retrieved 2019-03-07.
External links[edit]
- Official website
Office Open XML support[edit]
Secure ftp client. 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[edit]
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 2Compound 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[citation needed]) – 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[edit]
| Legend: | Old version, not maintained | Older version, still maintained | Current stable version | Latest preview version | Future release |
|---|
Version number | Date of release |
|---|---|
| Current stable version:4.1.2 | 14. February 2020 |
| Old version, no longer maintained: 4.1.1 | 20. October 2019 |
| Old version, no longer maintained: 4.1.0 | 09. April 2019 |
| Old version, no longer maintained: 4.0.0 | 07. September 2018 |
| Old version, no longer maintained: 3.17 | 15. September 2017 |
| Old version, no longer maintained: 3.16 | 19. April 2017 |
| Old version, no longer maintained: 3.15 | 21. September 2016 |
| Old version, no longer maintained: 3.14 | 2. March 2016 |
| Old version, no longer maintained: 3.13 | 29. September 2015 |
| Old version, no longer maintained: 3.12 | 11. May 2015 |
| Old version, no longer maintained: 3.11 | 21. December 2014 |
| Old version, no longer maintained: 3.10.1 | 18. August 2014 |
| Old version, no longer maintained: 3.10 | 8. February 2014 |
| Old version, no longer maintained: 3.9 | 3. December 2012 |
| Old version, no longer maintained: 3.8 | 26. March 2012 |
| Old version, no longer maintained: 3.7 | 29. October 2010 |
| Old version, no longer maintained: 3.6 | 14. December 2009 |
| Old version, no longer maintained: 3.5 | 28. September 2009 |
| Old version, no longer maintained: 3.2 | 19. October 2008 |
| Old version, no longer maintained: 3.1 | 29. June 2008 |
| Old version, no longer maintained: 3.0.2 | 4. February 2008 |
| Old version, no longer maintained: 3.0.1 | 5. July 2007 |
| Old version, no longer maintained: 3.0 | 18. May 2007 |
| Old version, no longer maintained: 2.5.1 | 29. February 2004 |
| Old version, no longer maintained: 2.5 | 29. February 2004 |
| Old version, no longer maintained: 2.0 | 26. January 2004 |
| Old version, no longer maintained: 1.5.1 | 16. June 2002 |
| Old version, no longer maintained: 1.5 | 6. May 2002 |
| Old version, no longer maintained: 1.2.0 | 19. January 2002 |
| Old version, no longer maintained: 1.1.0 | 4. January 2002 |
| Old version, no longer maintained: 1.0.2 | 11. January 2002 |
| Old version, no longer maintained: 1.0.1 | 4. January 2002 |
| Old version, no longer maintained: 1.0.0 | 30. December 2001 |
See also[edit]
References[edit]
- ^'History of Changes'. 2020-02-14. Retrieved 2020-02-15.
- ^ abcdSundaram, Elango (22 March 2004), 'Excelling in Excel with Java', JavaWorld, retrieved 2020-07-21
- ^POI homepage from October 2004, Coyote Song, archived from the original on 2004-10-15, showing original explanations for naming.
- ^SourceSense
- ^McDougall, Paul (26 March 2008). 'Microsoft Eyes Open Source Components for Office 2007'. InformationWeek. Retrieved 2020-07-21.
- ^Oliver, Andrew C. (27 March 2008), 'Rejection of any ENCUMBERED Microsoft Donation to POI', POI development mailing list archives, retrieved 2020-07-21
- ^ abcde'POI API Documentation'. Poi.apache.org. Retrieved 2019-03-07.
- ^'POI-HPBF - Java API To Access Microsoft Publisher Format Files'. Poi.apache.org. Retrieved 2019-03-07.
- ^Codeplex NPOI, Microsoft, archived from the original on 2012-03-28[better source needed]
- ^POI-HSMF, Apache, archived from the original on 2011-08-07, retrieved 2011-07-31
- ^POI-HSSF, Apache
- ^POI-HWPF, Apache
- ^POI-HSLF, Apache
- ^POI-Ruby, Apache
- ^'HadoopOffice for Hive/Flink/Spark'. Github.com. 2018-07-19. Retrieved 2019-03-07.
- ^'Spark Excel'. Github.com. Retrieved 2019-03-07.
External links[edit]
- Official website
XLSX to XLS converter performs conversion of XLSX files and enables to read the files in older versions of excel. They can perform reliable and quick conversions which help one to view them without installing the latest version of Microsoft Office.
Related:
To know more about them one can search Google using 'xlsx to xls converter free download', 'xlsx to xls converter Microsoft', 'xlsx to xls converter free. download full version' or 'xlsx to xls converter offline'.
Convert XLSX to XLS
This online XLSX to XLS converter performs an easy and quick conversion. It allows dragging and dropping or selecting the file to convert. The converted files are sent to one's email id to download them. It also allows entering the URL of the file that is to be converted.
XLSX TO XLS
This online conversion software enables quick conversion of files with high accuracy and speed. It allows choosing the file to be converted and on conversion the file can be downloaded. It also allows sharing converted file to social media like FaceBook and Twitter. It is easy-to-use software and comes with a simple interface.
Xlsx Full Form
Convert.Files
This online conversion software performs conversion by choosing the file from a location and uploading it or by entering the URL. On conversion, it allows downloading the converted file as well as provides an option to download the file by sending the download link to one's email id. It can perform quick as well as accurate conversion.
XLSX to XLS Free Converter
Converting document from .xlsx to .xls will make it more convenient to open in older versions of excel and this software performs this conversion easily and quickly. This software works for both PC and Android devices. It is quick to download as well as install. It is lightweight and easy-to-use software.
Convert XLSX to XLS
This software uses advanced techniques like multi-thread engines to convert XLSX to XLS conversion instantly. It does not require Microsoft Office to be installed to perform the conversion. It allows converting selected columns as well as multiple file conversion using batch processing. It allows converting by sorting the file too. It supports command line to convert files.
DocsPal
DocsPal is online software which enables conversion of XLSX to XLS format. It allows uploading the file to be converted as well as entering the URL from where the file has to be fetched. It allows downloading the converted file as well as enable to receive the link to download the file.
Convert to Excel Xls
Convert to Excel Xls is online software which enables batch conversion of XLSX files to XLS format either by uploading one or more files as well as entering multiple URLs. It performs conversion easily and quickly as well as accurately. It is extremely simple to use and performs conversion securely.
Most Popular XLSX to XLS Converter – Convert XLSX to XLS Online
This is online XLSX to XLS conversion software. It can perform conversion quickly by uploading the file to be converted and allows downloading the converted files easily. It does not require either email id or registration to perform a conversion. It is freeware and performs the conversion in a safe and secure way.
What is XLSX to XLS Converter?
XLSX to XLS Converter provides quick solution to view advanced version excel file when a user is having an older version of Microsoft Office in their system. They can convert multiple files through the batch process and enable quick conversion. There are many online as well as desktop versions available and one can use them as per their requirements.
Csv Full Form
Some of them work in command line mode as well. To know more about their varieties one can search Google using 'xlsx to xls converter free download for windows xp', 'xlsx to xls converter Microsoft download', 'xlsx to xls converter freeware' or 'xlsx to xls converter free download. software'. You may also see PSD to HTML Converters
Pptx Full Form
These XLSX to XLS converters comes with advanced techniques to perform smooth and secure conversion of excel files. They provide easy as well as an instant solution to open XLSX files without the need of installing the latest version of Microsoft Office. They are highly dependable and handy tools for any organization.
Docx Full Form
Related Posts
