aspose file tools*
The moose likes Java in General and the fly likes Creating an Excel file from Java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "Creating an Excel file from Java" Watch "Creating an Excel file from Java" New topic
Author

Creating an Excel file from Java

Javed Sardar
Ranch Hand

Joined: Sep 10, 2002
Posts: 33
HI,
Is it possible to generate an Excel file from Java. This is possible in VB, we need to make an instance of Excel file, get a handle of it, put data into the selected row-column and save the file.
Is it posible to do a similar job in Java ?
Regards,
Sardar.
Manish Hatwalne
Ranch Hand

Joined: Sep 22, 2001
Posts: 2578

There's JExcel (http://threebit.net/projects/jexcel.shtml). See if it is of nay help.
- Manish
Amit Manurkar
Greenhorn

Joined: Apr 03, 2003
Posts: 11
Hi,
You can also try the POI from Apache. A good API for reading / writing Excel / Word files.
http://jakarta.apache.org/poi/index.html


Amit Manurkar
Cindy Glass
"The Hood"
Sheriff

Joined: Sep 29, 2000
Posts: 8521
Sure this is possible. You need to find the dll that VB is using, and then write some JNI in your java app to interface with that dll.
Alternatively, if you are just posting data to Excel you can just treat it like a database and use JDBC to write to it. If you do a search on the JDBC forum for "Excel" you will find quite a bit of conversation about this.


"JavaRanch, where the deer and the Certified play" - David O'Meara
Javed Sardar
Ranch Hand

Joined: Sep 10, 2002
Posts: 33
Thanks very much Cindy,
The JDBC thing is what I wanted.
Regards,
Sardar.
 
 
subject: Creating an Excel file from Java
 
Similar Threads
How to export from excel or access file to SQL through some java program?
is it possible to save and retrieve data from MS Excel Datasheet using servlet/JSP?
Rename Excel File using Java
Automate Excel Loading into Database
help regarding creating charts in excel from java code using any private APIs: