JSP To EXCEL

[sureshsri1981]

hi all,

how to convert JSP page to Excel file using JSP or Java Script. please help me

by

Suresh

[tommy]

try this

<&#37;
String mimeType = "application/vnd.ms-excel";
response.setContentType(mimeType);
%>

[sureshsri1981]

hi all,

Thanks

by

Suresh

[delishen]

Tommy,
That works for excel before 2007. For MS office 2007, I did the same thing, but always give me a warning message about the extension error through I can open it with excel 2007. I tried to add the mime-type to my tomcat configuration file, but still could not export to .xlsx file. Help would be appreciated!

<mime-mapping>
<extension>xlsx</extension>
<mime-type>application/vnd.openxmlformats-officedocument.spreadsheetml.sheet</mime-type>
</mime-mapping>


In my jsp file:

response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");

response.setHeader("Content-Disposition", "attachment; filename=\""+ myfile.xlsx+"\"");

I won't be able to open myfile.xlsx. However, if i save the file, and rename to myfile.xls, then I will be able to open it with excel 2007. It appears that the format is still in excel 2003/earlier version, not in 2007 formant.