wood burning stoves 2.0*
The moose likes JSP and the fly likes Export to Excel Issue Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JSP
Bookmark "Export to Excel Issue" Watch "Export to Excel Issue" New topic
Author

Export to Excel Issue

Nagesh Rachakonda
Ranch Hand

Joined: Dec 04, 2003
Posts: 34
Hi Pals,
How to generate/create an Excel Workbook (consists of 1-many worksheets) dynamically using the data in several objects available in a JSP page? I am able to create a worksheet and download to the client end. I did this using the setContentType and setHeader methods.
I appreciate if anyone can give me an idea of doing this (ideally using Java technologies).
Also, I am able to create workbook using JavaScript. This is taking ample time to download (in this situation, it opens client Excel application and so the workbook, and writes data row by row. Client can see this operation). But I would like to be fast and simple.
Thanks
Nagesh.
Gowrishankar Mudaliar
Ranch Hand

Joined: Oct 20, 2001
Posts: 39
Try jakarta POI. This has libraries to convert data in java to Excel (and word)
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Export to Excel Issue