Generate Excel File Using ASP

[LBT]

Hi experts,

With response.contenttype = "application/vnd.ms-excel", I can easily export
my data to Excel which is embeded and shown within a browser.

If I'm going to save the Excel file through ASP programming, which method
can I use? I need to save the data to Excel file with dynamic name (the file
name should contain key values and appended with system datetime).

Thanks a lot

 

[Tom Kaminski [MVP]]

Hi experts,

With response.contenttype = "application/vnd.ms-excel", I can easily export
my data to Excel which is embeded and shown within a browser.

If I'm going to save the Excel file through ASP programming, which method
can I use? I need to save the data to Excel file with dynamic name (the file
name should contain key values and appended with system datetime).

Use this method, but add some variables in the filename as appropriate:
http://www.aspfaq.com/show.asp?id=2129

 

[Bullschmidt]

For FSO code to create an Excel file to be stored on the server:

Creating the Excel File Server Side
http://www.greggriffiths.org/webdev/both/excel/serverside.html

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
http://www.Bullschmidt.com
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...