Response.Clear
Response.ContentType = “application/vnd.ms-excel”
Response.AddHeader “content-disposition”, “filename=ExcName.xls”
但會有中文亂碼的問題，必須在前面加上:
Response.Write “<meta http-equiv=Content-Type content=text/html;charset=utf-8>”
@@未測試過:
文本：vnd.ms-excel.numberformat:@
日期：vnd.ms-excel.numberformat:yyyy/mm/dd
數字：vnd.ms-excel.numberformat:#,##0.00
貨幣：vnd.ms-excel.numberformat:￥#,##0.00
百分比：vnd.ms-excel.numberformat: #0.00%