This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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)
subject: Export to Excel Issue
Similar Threads
Exporting some data to excel
Download it in different sheets in Excel
Writing File(Excel) in ResultSet
web app. using MySQL 4.0, JSP, Tomcat & Jexcel