蘭庭論壇

標題: ASP輸出轉成EXCEL [打印本頁]

作者: 李亮寬 時間: 2014-12-29 11:47
標題: ASP輸出轉成EXCEL
'原木本輸出程式照copy,加入以下程式可轉成EXCEL使用
Response.AddHeader "content-disposition","attachment; filename=學生成績.xls"
  Response.Charset ="BIG5"
  Response.ContentType = "Content-Language;content=zh-tw"
  Response.ContentType = "application/vnd.ms-excel"
  Response.write "<meta http-equiv=Content-Type content=text/html; charset=BIG5>" '使excel 不產生亂碼
.
.
.
.
.
.
.
response.end '轉成EXCEL最後一行加入response.end

歡迎光臨蘭庭論壇 (http://120.101.203.2/)