GridView 匯出到EXCEL

string strFileName = DateTime.Now.ToString("yyyyMMdd-hhmmss");
        System.Web.HttpContext HC = System.Web.HttpContext.Current;
        HC.Response.Clear();
        HC.Response.Buffer = true;
        HC.Response.ContentEncoding = System.Text.Encoding.UTF8;//設定輸出資料流為簡體中文
        if (Model == 1)
        {
            //---匯出為Excel檔案
            HC.Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(strFileName, System.Text.Encoding.UTF8) + ".xls");
            HC.Response.ContentType = "application/ms-excel";//設定輸出檔案類型為excel檔案。
        }
        else
        {
            //--- 匯出為Word檔案
            HC.Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(strFileName, System.Text.Encoding.UTF8) + ".doc");
            HC.Response.ContentType = "application/ms-word";//設定輸出檔案類型為Word檔案。
        }
        System.IO.StringWriter sw = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);
        this.GridView1.RenderControl(htw);
        HC.Response.Write(sw.ToString());
        HC.Response.End();

 

 

當然這個代碼還需要:

public override void VerifyRenderingInServerForm(Control control)
    {

    }

 

沒有這個的話將提示:gridview ....runat server...的錯誤提示!!