How to output JSP page to Excel ?

[Sudharshan Reddy Ch]

Hi all,

I have a requirement like I should convert my JSP output to Excel file by clicking a button. Please help me.

Sample code is more helpful.

Thanks & Regards,
Sudha C Reddi.

[Paul Clapham]

Reanalyze your requirement into something that makes more sense. Like this: "Produce an Excel file containing the same data as the JSP in response to a button click".

[Carol Enderlin]

In my form I've got a button "Save to Excel". I'm using jstl's if with a test whether the button was pressed and if so it sets a header and content type...viola an excel file with the html.

Ugh, if someone knows how to do this without the ugly scriptlet I'd be grateful for a tip.

...
<input type="submit" value="Save to Excel" name="excel">
... 
<c:if test="${ ! empty param.excel}">
   <% 
         response.setHeader("Content-Disposition","attachment;filename=myfilename.xls"); 
     response.setContentType("application/vnd.excel");
  %>
</c:if>

[ October 27, 2006: Message edited by: Carol Enderlin ]

[vijaya bacina]

Try Apache Poi for export to excel functionality .it is easy to use and we can even format each cell programtically. otherwise try response.setContentType();

[Carol Enderlin]

There are lots of ways to do it, comma delimited, poi, html, xml.

[Rashid Mayes]

This article may be helpful.

http://www.javaworld.com/javaworld/jw-10-2006/jw-1019-xmlexcel.html

[Eddy Lee Sin Ti]

For contentType approach, you might want to set it in the directive to cause the entire page to render as Excel

<%@ page contentType="application/vnd.ms-excel; charset=UTF-8" %>

Cheers.

[Ben Souther]

JspAndExcel