GridView匯出為Excel亂碼解決方案

GridView匯出Excel經常會出現亂碼，這裡給出一個解決方案，記錄下，備用。

 

/// <summary>
/// 匯出Excel（自訂編碼）
/// </summary>
/// <param name="GridView1"></param>
/// <param name="title"></param>
public static void ExportExcel(System.Web.UI.WebControls.GridView GridView1, string title, string encoding)
{
    //標題
    byte[] bTitle = System.Text.Encoding.GetEncoding(encoding).GetBytes(title + "<br><br>");
    StringBuilder sb = new StringBuilder();
    sb.Append(System.Text.Encoding.GetEncoding(encoding).GetString(bTitle));

    //報表內容
    System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
    System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
    GridView1.RenderControl(oHtmlTextWriter);
    byte[] bContent = System.Text.Encoding.GetEncoding(encoding).GetBytes(oStringWriter.ToString());
    sb.Append(System.Text.Encoding.GetEncoding(encoding).GetString(bContent));

    //輸出
    System.Web.HttpContext.Current.Response.Clear();
    System.Web.HttpContext.Current.Response.Buffer = true;
    System.Web.HttpContext.Current.Response.Charset = encoding;
    System.Web.HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=FileName.xls");
    System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding(encoding);
    System.Web.HttpContext.Current.Response.HeaderEncoding = System.Text.Encoding.GetEncoding(encoding);
    System.Web.HttpContext.Current.Response.ContentType = "application/ms-excel";    //設定輸出檔案類型為excel檔案。 
    System.Web.HttpContext.Current.Response.Write("<meta http-equiv=Content-Type content=\"text/html; charset="+encoding+"\" >");

    System.Web.HttpContext.Current.Response.Write(sb.ToString());
    System.Web.HttpContext.Current.Response.End();
}