POI/POI Serialization Project / News: Recent posts

new builds have been cut from our new space in jakarta. They're currently available here on sourceforge as we anxiously await someone mounting them on apache. In the meantime, though, help yourself to version 1.4583: http://poi.sourceforge.net/jakarta-poi-1.4583-dev\*

On behalf of the whole community I'd like to thank Sourceforge and VA Linux for kindly providing us with hosting services.

POI has grown quite a bit and has been way more successful than we'd thought possible. As a result we've been accepted into the Jakarta project and Cocoon project (jakarta.apache.org and xml.apache.org/xml). The APIs will move to Jakarta and the Cocoon-based stuff will become part of Cocoon itself. ... read more

The POI project has been accepted into the Jakarta project and will be moving their shortly. Please subscribe to the new mail lists by mailing:

poi-dev-subscribe@jakarta.apache.org and
poi-user-subscribe@jakarta.apache.org

The existing releases will continue to be supported, however an interim release will be announced soon.

I'd like to thank the users and developers of POI for making us a success and for their continued support as this project grows.... read more

POI development release 1.2.0 is now available for download. New in this release:
* styling support added to HSSFSerializer
* Fix for embedded graphs
* New DualHashMap used for SSTRecord
* iterators added/standardized in high level model
* very early graphing record support
* logging improvements

As no showstoppers were reported, I have, as promised earlier, released POI 1.0.2.

This is a bug fix release, with proper handling of very large (>8K) strings.

As promised yesterday, I've retrofitted POI 1.0.1 with the bug fix I added to the poi-dev branch. As the changes were substantial, it would be great if we could get some community testing on this before I release it as an official release.

The source has been tagged in cvs as poi-1.0.2; please download it, build it, try it out on your files. If I haven't heard of any showstoppers, I'll formally release the build Thursday evening (9ish EST).... read more

poi-dev 1.1.1 fixes bugs handling the reading and writing of HSSF streams containing very large (>8228 bytes) strings, with either 8-bit or 16-bit content.

Due to a probably rare but serious problem with Strings (in the rare event that a string broke perfectly at the end of 8228 bytes anywhere but in the first 8228 byte block), we've release a bugfix release.

This also includes the left out getMergedCell() property in HSSFCellStyle().

Sorry for any inconvience this bug caused. Our testing never happened to expose this problem (only real data could do that ;-) ). ... read more

This release contains some optimizations added since POI 1.0. Also includes a POIFS file viewer, net.sourceforge.poi.poifs.dev.POIFSViewer

After over six months in the making POI (http://poi.sourceforge.net) has released its first official release. One week ago we released a beta which has been heavily downloaded. Based on feedback we've gotten, bugs were fixed and tested and now you have it, fresh (baked?) POI. This may seem sudden, but we had one loooong alpha cycle. :-)

For those of you who do not know POI stands for Poor Obfuscation Implementation.... read more

Several folks have written asking if there was a mailing list. So now they have it. I never created it before because of the scary message saying "if you do this it can't be undone", well its done now.

To subscribe goto http://lists.sourceforge.net/mailman/listinfo/poi-general-user

The first Beta release of POI is now available. Those of you who have downloaded alpha versions should note that the packaging has changed *considerably* ...

The final alpha release of poi has been made available for download, along with the customary documentation, and now a source release as well.

We finally have the long awaited serializer, as well as a how-to for installing it.

The HSSF-Serializer for Cocoon 2 will allow you to create Excel reports using simple stylesheets. It utilizes the HSSF API and the POIFS API to do the pure java spreadsheet generation. (See http://sourceforge.net/projects/poi for more information.)

We're very near the end of the 1.0 cycle. The serializer is now in CVS (Good Job Marc!). I'm working on some examples based primarily on the cocoon examples (because they don't require additional setup). I'll have a how-to and some instructions very shortly. Look for an interim build tomorrow or Friday. ... read more

I've checked in a utility class called HSSFDataFormat and exposed accessor methods in HSSFCellStyle for getting/setting builtin text formats. After much internal debate I decided to cram this into 1.0 because its little. I'm not sure how intuitive this new feature is so as always user feedback is greatly anticipated, appreciated, awaited.

In HSSF 2.0 we'll hopefully allow custom formats, but no way I'd cram that in to this release. Its only a matter of days before 1.0-beta1 is released. ... read more

This release fixes the SST record bugs. Also included is better support for HSSF styles, formatting, color, and a new poifs how-to

You can tell we're getting popular -- users are ferreting out the 6-legged features, and we're knocking them out as fast we get the word.

Another HSSF read bug squashed flat.

0.12.1 includes a fix for an HSSF read bug that accidentally escaped our containment facility and snuck into the 0.12.0 release.

Enhancements: cell styling, row sizing, column width sizing. Improved javadoc. Updated "how-to". Support for 16-bit characters is back.

I just finished creating cell styling functionality for HSSF. This code is in CVS.

This means you can now change the font, set fill colors, borders, etc. For the impatient: an example of this you can look at oacp.hssf.dev.HSSF. I'm going to add support for BLANK cells then I'm going back over the code and adding javadoc and will shortly update the HOWTO. We'll be doing a build once that's done.
We don't yet have text format settings. I'll be working on that next.

Its now possible to get/set column width and row heights using HSSF as well as get/set default column widths and row heights using HSSF. This is in CVS and will occur in a build shortly.

The HSSF-Serializer is coming along well and should appear in a build shortly.

While I'm hoping to have styling in HSSF shortly, POI beta 1.0 seems to be rapidly approaching so it will depend on how stable I can make it.

New releases are available. poi-alpha 0.11.0 features HSSF refactoring and a bug fix; poi-doc 0.11.0 includes substantially updated HSSF documentation.

I'd just like to thank everyone again for their support and ask them to keep it coming. We're getting pretty close to 1.0-beta-1. POIFS is pretty much frozen. HSSF has just had its API reworked and some of its guts rearranged. While I think this will make it more usable and stable, more testing needs to be done to ensure that. Please try HSSF, bang it up and file bug reports.
Send us those spreadsheet and java files.... read more

Per Andy's announcement a couple of days ago, we've undergone some major restructuring of the file space. Also, Andy's finished the first cut at refactoring the HSSF code. All this is now bundled up in a new release. Enjoy.

Okay so "Sometime in November" for beta 1 is a miss. I blame this strictly on our scope expansion. Anyhow we're not going to miss it by much.

Here are the revised estimates and stauts:

This week

Big reorganization of CVS - see doc/poicvs.html for details of the new structure! I promise, whatever you're looking for has MOVED!

HSSF Serializer is in development, should be completed for a first cut around Dec 15... read more