Forums
This topic is locked
Table Export to EXCEL
Posted 11 Aug 2003 17:10:51
1
has voted
11 Aug 2003 17:10:51 Greg LeBreck posted:
In ASP with a SQL DB.I have a site for some sales reps. There is a report page that if you click on a linke for a customer you can get monthly totals. I would like to give the user the ability to view the report or have it exported to an Excel file.
Replies
Replied 13 Aug 2003 14:44:27
13 Aug 2003 14:44:27 Vince Baker replied:
Create the page as you want it (table) and then add this line just after the <body> tag:
<% Response.ContentType = "application/vnd.ms-excel" %>
And the page will open in Excel.
Regards
Vince
Visit my home: www.chez-vince.com
VBScript | ASP | HTML | SQL | Oracle | Hosting
<% Response.ContentType = "application/vnd.ms-excel" %>
And the page will open in Excel.
Regards
Vince
Visit my home: www.chez-vince.com
VBScript | ASP | HTML | SQL | Oracle | Hosting