View in Excel Format

hi,

is there any better way for generating the report in Excel Format from ASP page. well, I'm now using Response.ContentType = "application/vnd.ms-excel" to generate the report, but i feel that it is no so practical as I need to pass all the query string from a asp page (there has a link "view in excel format") to the excelformat.asp and copy paste the code from the asp page to excelformat in order to generate the report. Please advice!

This may not be what you are after, but here's what I do....

Basically I use the FileSystemObject to output the data to a csv and then give a direct link to that file. As the extension is .csv, the browser should open it in Excel format.

However, this method only provides a means for getting the data into Excel - it does not do any formatting in Excel itself (column widths, font settings, etc)