Displaying output in Excel via ASP
Hi
I've managed to get an Excel sheet opened up via an ASP page with user specific data in it. The problem is, rather than having it opened up and displayed in a new window i need the user to be able to download the file with all the formatting (ie have all the headings as bold, gridlines enables etc) already done to it.
Here's the code that makes the content of the asp page into an Excel sheet:
Response.ContentType = "application/vnd.ms-excel"
Any idea how i can go about doing this?
Thanks for your help in advance.
|