generate excel report

[charon]

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!

[whammy]

Hmm, you should use the search feature of the forum, there are quite a few good answers to this question! ;-)

[charon]

i use keyword "excel format", "Report", "View In Excel", couldn't find what i want.

[whammy]

Hmm, I was thinking about this post:

http://www.codingforums.com/showthread.php?s=&threadid=12144&highlight=excel+file

Which was also in answer to one of your questions... so I'm not sure what you're getting at. ;-)