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...的错误提示!!