For Programmers: Free Programming Magazines  


Home > Archive > ASP > March 2005 > Generate Excel File Using ASP









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Generate Excel File Using ASP
LBT

2005-03-29, 8:55 am

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]

2005-03-29, 3:55 pm

"LBT" <LBT@discussions.microsoft.com> wrote in message
news:939C2D4C-0AA3-4814-8B19-B980D9EF4FA9@microsoft.com...
> 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

--
Tom Kaminski IIS MVP
http://www.microsoft.com/windowsser...ty/centers/iis/
http://mvp.support.microsoft.com/
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS


Bullschmidt

2005-03-31, 3:55 pm

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...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...


*** Sent via Developersdex http://www.developersdex.com ***
Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com