Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

generating excel report from jsp

 
Srikrishna DhumalRao
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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,
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34839
369
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Srikrishna DhumalRao
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Jeanne Boyarsky
I will follow the link
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic