aRo` automating your e-commerce

how to create an excel file from an ASP page

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;

Popularity: 5% [?]