aspose file tools*
The moose likes JSP and the fly likes generating excel report from jsp Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JSP
Bookmark "generating excel report from jsp" Watch "generating excel report from jsp" New topic
Author

generating excel report from jsp

Srikrishna DhumalRao
Greenhorn

Joined: Oct 05, 2004
Posts: 17
Hi all,
I need to generate an excel report from a JSP. Now, i am generating excel report by setting content type to application/vnd.ms-excel. But the problem is I wanted to have monthly report in one sheet and yearly report in the other sheet, which I am not able to accomplish. I will be grateful if someone throws light in this aspect.
Thanks in adance,


srikrishna
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30929
    
158

Srikrishna,
Take a look at POI's HSSF library for generating Excel. It provides finer control including multiple sheets.

This really should be done from a servlet rather than a JSP since it is all java code.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Srikrishna DhumalRao
Greenhorn

Joined: Oct 05, 2004
Posts: 17
Thanks Jeanne Boyarsky
I will follow the link
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: generating excel report from jsp