Asp.NET中把DataTable匯出為Excel ，中文有亂碼現象解決辦法

標籤：position   text   asp.net   編碼格式   utf8   ble   亂碼   返回   meta   

　　　　　 //DataTable為要匯出的資料表

　　　　　  DataGrid dg = new DataGrid();
                dg.DataSource = DataTable;
                dg.DataBind();

                //如果檔案名稱有中文，指定編碼
                string fileName = HttpUtility.UrlEncode("JobHistoryList", Encoding.UTF8).ToString();

                //設定編碼格式
                HttpContext.Current.Response.Clear();
                HttpContext.Current.Response.Charset = "UTF-8";// "UTF-8"或者"GB2312"
                HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";//text/csv
                HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8;
                HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + fileName + ".xls");
                //匯出excel
                System.IO.StringWriter oSW = new System.IO.StringWriter();
                HtmlTextWriter oHW = new HtmlTextWriter(oSW);
                dg.RenderControl(oHW);

              

　　　　　　//輸出時加上"<meta http-equiv=\"content-type\" content=\"application/ms-excel; charset=UTF-8\"/>"解決編碼問題

　　　　　　//返回瀏覽器，
                HttpContext.Current.Response.Write("<meta http-equiv=\"content-type\" content=\"application/ms-excel; charset=UTF-8\"/>" + oSW.ToString());
                HttpContext.Current.Response.End();

Asp.NET中把DataTable匯出為Excel ，中文有亂碼現象解決辦法