Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Export to Excel Issue

 
Nagesh Rachakonda
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 39
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Try jakarta POI. This has libraries to convert data in java to Excel (and word)
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic