gridview里的数据导出为excel表

using System.IO;                     //需要使用到的命名空间   

protected void Button1_Click(object sender, EventArgs e)         // 按钮响应

    {
        Response.ClearContent();
        Response.AddHeader("content-disposition", "attachment; filename=MyExcelFile.xls");
        Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
        Response.ContentType = "application/ms-excel";
        StringWriter sw = new StringWriter();
        HtmlTextWriter htw = new HtmlTextWriter(sw);
        this.GridView1.RenderControl(htw);
        Response.Write(sw.ToString());
        Response.End();


    }
    //你同时还要重载VerifyRenderingInServerForm方法,不然报错。
    public override void VerifyRenderingInServerForm(Control control)
    {
    }