Gridview导出excel

    protected void Button_ServerClick(object sender, EventArgs e)
    {
        Excel ExportExcel = new Excel();
        string Year = System.DateTime.Now.Year.ToString();
        string Month = System.DateTime.Now.Month.ToString();
        string Day = System.DateTime.Now.Day.ToString();
        string DateString = Year + "-" + Month + "-" + Day;
        ExportExcel.Generate("DangAn", DateString, GridView1);
    }

    public override void VerifyRenderingInServerForm(Control control)
    {
        （必须有）
            //base.VerifyRenderingInServerForm(control);
    }

    public void Generate(string Typename, string scswId, GridView TempGrid)
    {

        HttpContext.Current.Response.Clear();
        HttpContext.Current.Response.Charset = "utf-8";
        string Filename = Typename + scswId + ".xls";
        HttpContext.Current.Response.AppendHeader("Content-Disposition", "online;filename=" + Filename);
        HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");
        HttpContext.Current.Response.ContentType = "application/ms-excel";
        System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
        TempGrid.RenderControl(oHtmlTextWriter);
        HttpContext.Current.Response.Write(oStringWriter.ToString());
        HttpContext.Current.Response.End();
    }