• Post Reply Bookmark Topic Watch Topic
  • New Topic

Error opening MS Excel report  RSS feed

 
Sandeep Korgaonkar
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 '<ServerName>/<FileName>.jsp'.�
(Error pops up for MS Excel 2000 and 2002 with MS Internet Explorer 6.0)
Here is a sample code that demonstrates this issue:
<%
// MS Word Works well everytime
//response.setContentType("application/msword");

// MS Excel
// Dose not work first time
//response.setContentType("application/x-msexcel");
// Dose not work first time
response.setContentType("application/vnd.ms-excel");
%>
<html>
<body>
Test Successful!
</body>
</html>
Please let me know if you have encountered such an issue and have any suggestions.
Thanks,
Sandeep.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!