Tuesday, June 24, 2014

Export Data in Excel with VBScript Classic ASP

As i found lot of articles on the Internet, how to export a page to Excel using VBScript Classic ASP. There are very simple way to Create excel page using vbscript with the help of given steps.

Step 1. 
<%
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "Content-Disposition", "attachment; filename=My_List.xls"
%>

Step 2. 
<html xmlns:x="urn:schemas-microsoft-com:office:excel">