• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem with excel

 
Karthik Vijayarajan
Ranch Hand
Posts: 43
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
I am trying to open an excel sheet from my JSP. I used the following code in my JSP to get it working.

response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-disposition", "attachment;filename=ExcelBaselineMovedOut.xls");

When the browser is opening the excel, i am getting a message that reads


'C:\Documents and Settings\local files....\Temporary internet files\Content.IE5\7VCTHHP2\ExcelBaselineMovedOut.xls'cannot be found.
check the spelling of the file name and verify that the file location is correct.If you are trying to open the file from your list of most recently used files on the File menu,make sure that the file has not been renamed,moved or deleted


I tried deleting the temporary internet files. It works sometimes,but most of the times it doesn't work fine.

Would be great if someone can advice on this.

Thanks
Karthik
 
Ben Souther
Sheriff
Posts: 13411
Firefox Browser Redhat VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm guessing this is a pretty large file.

I've seen this happen with MSIE when there isn't enough room in your temporary internet files dir (TIF) to hold the file. Instead of telling you this, MSIE just skips the download and moves on to the section of code that tries to read the file. For us, telling the client to empty their TIF dir usually satisfies them.

Try increasing the max size setting for your TIF directory.
 
Karthik Vijayarajan
Ranch Hand
Posts: 43
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
Thanks for the reply.
Even if i have 10 records,i am not able to open the excel.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic