aspose file tools*
The moose likes JDBC and the fly likes problem regarding excel display through servlets in IE 5.0/5.5/6.0. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "problem regarding excel display through servlets in IE 5.0/5.5/6.0." Watch "problem regarding excel display through servlets in IE 5.0/5.5/6.0." New topic
Author

problem regarding excel display through servlets in IE 5.0/5.5/6.0.

omi om
Greenhorn

Joined: Mar 11, 2003
Posts: 2
The excel file opens with the help of servlet.It works fine with IE 4.0 but it fails to open in IE 5.0 /5.5/6.0 and pops up with the window saying -
what would you like to do with this file-
1. open this file from currrent location.
2. Save this file to disk.
what could be done to avoid this when MIME-TYPE is already set.
Any help will be appreciated.
Thanks.
Kirtikumar Puthran
Ranch Hand

Joined: Mar 04, 2003
Posts: 37
I am not absolutely sure...but I think this is not a browser problem. I had encountered this exact problem some time back, with .csv files which I wanted to open in IE using Excel. It used to show me this dialog :

what would you like to do with this file-
1. open this file from currrent location.
2. Save this file to disk.


I then tried the following:-
I associated the .csv with Excel (I was on Windows and I just right-clicked on a csv file and opened it with Excel. I also checked the checkbox saying that always open .csv using Excel). After doing this, every .csv I open in IE, it opens in Excel inside the browser.
I don't know if any one else has tried this. But, there might be a nicer way of doing this in servlets. Can anyone throw some more light on this?

Rgds,
Kirtikumar Puthran
[ March 12, 2003: Message edited by: Kirtikumar Puthran ]

Regards,<br />Kirti
SJ Adnams
Ranch Hand

Joined: Sep 28, 2001
Posts: 925
check the content type is set in the response.
maybe telnet into port 80 to check that it is actually getting set.
the query string may need to end in a '.xls' (not convinced this makes a difference)
check the browser settings & I guess like Kirtikumar says - you've associated excel with the file type.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: problem regarding excel display through servlets in IE 5.0/5.5/6.0.