Classic ASP Discussion - View in Excel Format

Print Page | Close Window

View in Excel Format

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=1308
Printed Date: 29 March 2026 at 5:16am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: View in Excel Format

Posted By: charon
Subject: View in Excel Format
Date Posted: 24 March 2003 at 9:00pm

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!

Replies:

Posted By: michael
Date Posted: 24 March 2003 at 10:04pm

The best way for that is to write/use a component.

Posted By: Gary
Date Posted: 25 March 2003 at 2:21am

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)