The Apache POI is a popular open source library used to read, write, and manipulate MS Office and Open Office files by using Java code. The library is one of the many open source products maintained by Apache Software Foundation (ASF) contributed to the community. The library contains classes and methods to decode file formats based on Open Office XML standards and Microsoft OLE2. Although the library is capable of manipulating Word, Excel spreadsheet and PowerPoint files, this article mainly focuses on spreadsheet documents, only to make it brief.

1. The Program Used To Create This Object Is Acrobat Word 2010
2. The Program Used To Create This Object Is Package Word For Kids

The Apache POI Library. Intriguingly, in the name Apache POI, the POI stands for 'Poor Obfuscation Implementation' and the goal of the library is to provide Java APIs for manipulating various file formats based upon the Office Open XML standards (OOXML) and Microsoft's OLE 2 Compound Document format (OLE2). In short, this enables one to read and write MS Excel, MS Word, and MS PowerPoint files by using Java code.

Most Microsoft Office files—such as XLS, DOC, PPT, and MFC serialization API-based file formats—are based on OLE2 standard. The OLE, basically, is a proprietary technique developed by Microsoft, and provides the format for linking objects and embedding objects within container documents.

The first format is called OLE1.0 format where the linked object and the embedded object data is laid out as a sequence of bytes within the container document. The second version, the OLE2.0 format, leverages OLE Compound File Technology where the linked object or embedded object data is contained in this storage in the form of OLE Compound File Stream objects.

The Program Used To Create This Object Is Acrobat Word 2010

Refer to for more details on this. The Apache POI library provides library APIs for the OLE2 file system called POIFS and OLE2 Document Properties called HPSF. Apache POI ComponentsThe Apache POI library provides classes and methods to work with OLE2 Compound Documents of MS Office. Here is a brief overview of the most commonly used ones:. POIFS for OLE2 Documents: The POIFS stands for Poor Obfuscation Implementation File System. Engine block manufacturing process pdf.

This is the basic POI element implemented in the library to port OLE2 Compound Document. It supports read and write functionality for the non-XML binary Microsoft Office format. All APIs of the POI library are built upon this.: The HSSF stands for Horrible Spread Sheet Format. It is a Java implementation port for the Excel 97 file format or for.xls files. XSSF stands for XML Spread Sheet Format and it is a port for the OOXML file format or.xlsx file format.: The HWPF stands for Horrible Word Processor Format.

It is a limited read-only port for the older Word 6 or Word 95 file format. The XWPF stands for XML Word Processor Format. It is a Java implementation port for the Word 2007.docx file format.

Both implementations support limited functionality.: The HSLF stands for Horrible Slide Layout Format. The XSLF stands for XML Slide Layout Format. Both of these provide read, write, create, and modify capability of PowerPoint presentations whereas HSLF supports the PowerPoint 97 format and XSLF supports later versions. HPSF: The HPSF stands for Horrible Property Set Format. It is particularly used to work with document properties such as setting the title, category, author, date of modification and so forth of a document.: The HDGF stands for Horrible Diagram Format. This component contains classes to work with the Visio binary file format. It provides low-level, read-only APIs to access Visio Documents and VSD files.

The XDGF stands for XML Diagram Format. It is for the Visio XML file format or VSDX files.

HPBF: The HPBF stands for Horrible Publisher Format. It is a limited Java port to work with the MS Publisher file format. There is another alternative to working with spreadsheets, as the Apache POI Documentation suggests via the serializer, although it still uses HSSF indirectly. Cocoon can serialize any XML data source by applying the style sheet and designating the serializer. The HSSF and XSSF model is quite powerful and provides a number of classes and methods to deal with different aspects of an Excel document. This article tried to give a glimpse of what we can do with Apache POI.

The Program Used To Create This Object Is Package Word For Kids

We often need to write a utility program to bridge between an open and closed system. Apache POI can definitely serve our purpose as one of its kind.