open excel file

[heffingtond]

Hello-

I am attempting to redirect to an xls file that gets created by my web application. Instead of opening the file with Excel, the file is being displayed as raw text within a browser window. If, on the other hand, I open the same xls file by double clicking it in Windows Explorer, the file opens correctly in Excel.

 

I have included the following code prior to the creation and redirect to the file:

resp.setContentType("application/vnd.ms-excel");

 

The same redirect process is working for the PDF and html versions of the same report. Is there an additional step necessary to get the client to open an Excel file with Excel when a redirect id done on the server?

 

Thanks,

David.

[heffingtond]

I got this to work by defining the mime type in the web.xml:

<mime-mapping>

<extension>xls</extension>

<mime-type>application/vnd.ms-excel</mime-type>

</mime-mapping>

[edikk]

Try this:

response.setContentType("application/xls");

It work well for me.

Edik