BT

New Early adopter or innovator? InfoQ has been working on some new features for you. Learn more

Jakarta POI 3.0 - Java API To Access Microsoft Office Format Files

| by James Kao on May 28, 2007. Estimated reading time: less than one minute |
Version 3.0 of the Jakarta POI, the venerable Java library that provides the ability to read and write certain Microsoft Office documents, has been released. This release adds support for MS Excel formulas, improved PowerPoint support, and image extraction for MS Word documents.

Users of POI deal with a number of sub-projects to handle various aspects of these formats:
POIFS
Access to file structure for MS Office documents
HSSF
MS Excel data access
HWPF
MS Word data access
HPSF
Properties attributes for Office documents
HSLF
PowerPoint data access
POI-Ruby
Ruby bindings to gcj compiled binary libraries
The programming paradigm is relatively simple. A developer will use POIFS to create/open the document as a stream, and then connect that to the appropriate data access API (HSSF, HWPF, or HSLF) to actually interact with the content. Angsuman Chakraborty has written a concise piece that goes into more detail about using POI to read Excel files that is a good introduction and quick start guide.

This marks the last release of POI under the Jakarta subproject before being promoted to a top-level Apache project.

Rate this Article

Adoption Stage
Style

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread
Community comments

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Discuss

Login to InfoQ to interact with what matters most to you.


Recover your password...

Follow

Follow your favorite topics and editors

Quick overview of most important highlights in the industry and on the site.

Like

More signal, less noise

Build your own feed by choosing topics you want to read about and editors you want to hear from.

Notifications

Stay up-to-date

Set up your notifications and don't miss out on content that matters to you

BT