error « Excel « JSP-Servlet Q&A

1. Error opening MS Excel report

We are trying to resolve an issue related to creation and display of MS Excel reports. Creation of appropriate report is done in JSP, and content type is set to Excel. This JSP fails to create a report only for the first time. For the first time it pops up an error Microsoft Excel cannot access the file '/.jsp'. (Error pops ...

2. Error in excel report generation from jsp

Pls find the code below.. I am trying to generate the report from jsp: <% response.setContentType("application/"); response.setHeader("content-disposition","attachment;filename=test.xls"); %> Excel

----data comes here
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 ...