I have an asp page of data.
using the following. I am able to export the page to Excel
<% Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "Content-Disposition", "filename=excelfile.xls"%>
Works great. except the numbers on the spreadsheet are not treated as Numbers by Excel.
How do we export the numbers so they can be manipulated on the spreadsheet?