This week's book giveaway is in the Android forum.
We're giving away four copies of Head First Android and have Dawn & David Griffiths on-line!
See this thread for details.
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

Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Java » JSP
Bookmark "generating excel report from jsp" Watch "generating excel report from jsp" New topic

generating excel report from jsp

Srikrishna DhumalRao

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/ 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,

Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32304

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.

[OCA 8 book] [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

Joined: Oct 05, 2004
Posts: 17
Thanks Jeanne Boyarsky
I will follow the link
Consider Paul's rocket mass heater.
subject: generating excel report from jsp
It's not a secret anymore!