Expert: Srini Nagarajan - 10/20/2011

Question
hey i added a export to excel button on my asp page..
even the data is visible on the page..but when i clcik on export to excel button to get that in an excel sheet ..it shows the option to sav that but dost not display data. It shows blank sheet. what is happening i am not able to understand..help me out

Answer
Hi Lisha,

Use something like this

<%@ Language=VBScript %>
<%  Option Explicit

Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "Content-Disposition", "attachment; filename=excelTest.xls"
%>
<table>
   <tr>
       <td>Test</td>
   </tr>
</table>



Thanks

-Srini