DaniWeb IT Discussion Community - Java Excel connectivity code

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)

- Java (http://www.daniweb.com/forums/forum9.html)

- - Java Excel connectivity code (http://www.daniweb.com/forums/thread157974.html)

Java Excel connectivity code

Can some someone help me with a code to create a new Excel workbook and send data to the workbook using java.Please help me.

Re: Java Excel connectivity code

Google "Andy Khan JExcel"

Re: Java Excel connectivity code

We use the Jakarta POI API for that here at work.

Re: Java Excel connectivity code

Quote:

Originally Posted by Ezzaral (Post 738809)

We use the Jakarta POI API for that here at work.

Also Good, though I wonder if either of them have been adapted for Office 2007 yet.

The only thing I didn't like about POI, is that the library is so big. JExcel is much smaller, and yet I haven't found anything (yet) that it can't do that POI can. Then again, the reverse is also true, I haven't found anything POI can't do that JExcel can.

I have to admit though, that I definately have not had extensive experience with both of them. There are, I am sure, things one could do that I haven't attempted, yet.

Re: Java Excel connectivity code

The POI project page says they are working on Excel 2007 support, but I'm not sure how far along it is.

I haven't tried JExcel, so I can't really address the differences between them.