Jakarta's POI
I went to the kick-off party for my project tonight - too bad no one I'll be working with showed up! Oh well, everyone else that was there was very cool. Margaritas and nachos is always fun. I finally met the recruiter I've been working on the phone - and she's even cooler than she sounded on the phone. Apparently, there was a requirements meeting for the project on Monday. Doh! That would've probably been a good meeting to attend.
I heard that the hardest requirement will be parsing/reading Excel files, on a Unix box. I think the ol' POI project can come to the rescue for us.
The POI project consists of APIs for manipulating various file formats based upon Microsoft's OLE 2 Compound Document format using pure Java.
OLE 2 Compound Document Format based files include most Microsoft Office files such as XLS and DOC.
You just gotta love open source!
Matt, you could also check IBM's open source ExcelAccessor bean suite to be found on IBM's open source page. Disclaimer: I haven't tried either, it's just to give you some choice.
Hush! I just hope POI's father won't notice this ;-)
Posted by Greg Klebus on December 18, 2002 at 02:52 AM MST #
Posted by Andy on December 18, 2002 at 08:02 AM MST #
Posted by Matt Raible on December 18, 2002 at 08:07 AM MST #
Posted by Andy on December 18, 2002 at 09:12 AM MST #
Andy found me hiding here, argh ;-)
Seriously, I didn't know AccessorBeans only ran on Windows. Bummer. POI rocks here being cross-platform.
Posted by Greg Klebus on December 18, 2002 at 09:33 PM MST #
I feel kind of silly for commenting on a one year old blog entry, but:
JExcelAPI is much more powerful and easier to use than POI.
Posted by Michael on December 10, 2003 at 09:05 AM MST #