Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Creating an Excel file from Java

 
Javed Sardar
Ranch Hand
Posts: 33
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2591
Android Firefox Browser Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There's JExcel (http://threebit.net/projects/jexcel.shtml). See if it is of nay help.
- Manish
 
Amit Manurkar
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Cindy Glass
"The Hood"
Sheriff
Posts: 8521
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Javed Sardar
Ranch Hand
Posts: 33
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks very much Cindy,
The JDBC thing is what I wanted.
Regards,
Sardar.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic