create excel reports from jsp

[rishi]

I m working on one project where in that there is a report section,in
which we have to display data on jsp by feching the data from the
database.Everything is working good but i want to include a button on
jsp page and after clicking that button that jsp page genrates an
excel sheet and excel sheet displays the data in the same sequence as
it is in the jsp. Please help me with the code

 

[Tor Iver Wilhelmsen]

PÃ¥ Thu, 17 May 2007 13:46:02 +0200, skrev rishi

I m working on one project where in that there is a report section,in
which we have to display data on jsp by feching the data from the
database.Everything is working good but i want to include a button on
jsp page and after clicking that button that jsp page genrates an
excel sheet and excel sheet displays the data in the same sequence as
it is in the jsp. Please help me with the code

Generate a HTML table with the data in cells, send it with

Content-Type: application/vnd.ms-excel
Content-Disposition: attachment; filename=yourname.xls

I leave it to the reader to find out how you set these response headers in
a JSP.

 

[connerwalsh]

What about.. ?

Yeah, Mr. Wilhelmsen provided the most simple solution. If you are looking for any additional reporting capabilities down the road, I would even throw the step in for you to make sure the table is formatted in a way to allow an easy export.

-Conner
Excel Reports

 

[sherinwip]

Can you please help me in using the Excel 2007 using POI in jsp??