File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

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.
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)
I agree. Here's the link:
subject: Export to Excel Issue
jQuery in Action, 3rd edition