How to pull the data generated in ASP into an Activex control to genearte an xls file

[09shilpa]

I have an ASP page in which there are many combo box & list , based on its selection the query is written to fetch the data, now i hv a 3d button. on click of that button i have to pull that data & generate a report in excel format.
so can someone suggest me the way to proceed??

[iam_clint]

put this in your header

Response.ContentType = "application/vnd.ms-excel" filename = "What Ever"&replace(date(), "/", "-")&".xls"
 

on the page that you want to export to excel.

to make it look correct in excel use tables on your asp page like this.
the brackets are just my example of showing you where that value will end up in excel

<table>
<tr><td>Val1(a1)</td><td>val2(b1)</td><td>val3(c1)</td></tr>
<tr><td>Val1(a2)</td><td>val2(b2)</td><td>val3(c2)</td></tr>
<tr><td>Val1(a3)</td><td>val2(b3)</td><td>val3(c3)</td></tr>
</table>