Originally posted by Bruno Dery:
If you don't need fancy functions from Excel but just simply opening Excel directly from the file being downloaded, you can simply write a comma delimited file and it should open up with excel by default (if the user didnt changed his / her file associations, office sets .csv files associated with excel). So simply make sure you separate your columns by commas and your rows by newlines and name the file you output with the extension .csv.
yes, and add 'application/vnd.ms-excel' to 'Content-Type' in HTTP .
e.g.: <% response.setContentType( "application/vnd.ms-excel" ); %>