Pls find the code below..
I am trying to generate the report from jsp:
<%
response.setContentType("application/vnd.ms-excel.xls");
response.setHeader("content-disposition","attachment;filename=test.xls");
%>
<html>
<head>
<title>Excel</title>
</head>
<body>
<table>
----data comes here
</table>
</body>
When i run this, i am getting a Open/Save dialog box. If i try to save the excel, i am able to vdo that without any problem. And if an excel instance is already opened in my system, and i select open option from the dialog box, again this report is getting opened. But at the same time, if no excel instance is already opened, and i try to open, the excel I am getting an error saying:
"c:\Documents and Settings\199872\Local Settings\Temporary Internet Files\Content.IE5\WV5VMYZ5\test[1].xls could not be found" Please check the file name..etc..
Pls help me in solving this..
[ December 10, 2007: Message edited by: vidya archana ]