« Why do you blog? | Main | Now Running Tomcat... »
20021217 Tuesday December 17, 2002

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! Posted in Java at Dec 17 2002, 03:25:04 PM MST 6 Comments

Comments:

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 17, 2002 at 07:52 PM MST #

Yeah... you didn't want me to read it so you added a link so and clicked on it so that it would show up in my referrer log.. Cleaver way of hiding :-). So just for the record ExcelAccessor only works on Winblows because it uses native winblows code. So sure...go for it.. You'll have to install stuff like VMWare and Winblows first though... :-)

Posted by Andy on December 18, 2002 at 01:02 AM MST #

Cool - the blog comes through again - researching for me ;) I'm guessing that POI will allow me to read/extract information from an Excel document on a Solaris machine?

Posted by Matt Raible on December 18, 2002 at 01:07 AM MST #

Yes.

Posted by Andy on December 18, 2002 at 02: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 02: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 02:05 AM MST #

Post a Comment:
  • HTML Syntax: Allowed
Click me to subscribe
Matt Raible is a Web Architect who enjoys developing applications with open source technologies. Contact me for rates.
« December 2008
SunMonTueWedThuFriSat
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
   
       
Today

Recent Entries

Tag Cloud

abbie acegi appfuse denver flex grails gwt hibernate jack java jsf linkedin maven myfaces oscon rails skiing spring springmvc struts struts2 tapestry travel webframeworks wicket