標籤：style blog http color 使用 os io 資料
匯出為Excel有很多種寫法，對於一些複雜的格式，筆者喜歡在後台先拼成一個<table>，再使用Response輸出。
如果資料中包含中文或者一些特殊字元，可很多不規範的寫法都會導致頁面亂碼，這裡就把一種（筆者認為）最標準的格式帶給大家：
Page p = HttpContext.Current.Handler as Page;p.Response.Clear();p.Response.Buffer = true;p.Response.Charset = "UTF-8";p.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(filename, Encoding.UTF8) + ".xls");p.Response.ContentEncoding = Encoding.UTF8;p.Response.ContentType = "application/vnd.ms-excel";p.EnableViewState = false;p.Response.Write("<html><head><meta http-equiv=‘Content-Type‘ content=‘application/vnd.ms-excel; charset=utf-8‘ /></head>" + text + "</html>");p.Response.End();
以上代碼需注意兩點：
1）Charset/AppendHeader/ContentEncoding都必須統一使用UTF8
2）text裡面如果只有<table>,必須在前後加上<html></html>.為進一步規範，建議用以上代碼格式編寫
好了，現在應該是無論如何你怎麼匯出Excel，也沒有亂碼字元了。
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
