The code below gives a brief example on how to create an .xls file from an asp webpage. I use this to often to export my customers data(database) to an offline version wich they can use for archiving/reporting.

To to so you have to change the contenttype of the asp file to "application/vnd.ms-excel". This code has to be at the top of you page.

From then on you can use the response.write() function to write data to the .xls file. The data must be structured in table rows("<TR>") .

You can define the fields in the .xls with TH and TD.

code snippet:

PLAIN TEXT

ASP:

1. &lt;%
2. Response.ContentType = "application/vnd.ms-excel"
3. strfilename = "Filename_" &amp; Day(Date) &amp; Month(Date) &amp; Year(Date) &amp; ".xls"
4. Response.AddHeader "Content-Disposition","filename=" &amp; strfilename
5. response.expires = -1
6. %&gt;
7. strContent =”fill this variable(strContent) the same way as an html table”
8.  
9. &lt;able border="1" cellpadding="4" cellspacing="1" width="100%" %&gt;
10. &lt;% response.write strContent %&gt;
11. &lt;/table%&gt;

      

Related Posts

• download a file from an ftp server to your webserver
• capture the loading time of your php pages
• how to create a popup that returns data to the parent page
• basic linux commands overview
• sending a mail with asp on win2k3