C#中导出到Excel

  private void ToExcel(Control ctl, string FileName)
    {
        HttpContext.Current.Response.Charset = "UTF-8";
        HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8;
        HttpContext.Current.Response.ContentType = "application/ms-excel";
        HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + "" + FileName);
        ctl.Page.EnableViewState = false;
        System.IO.StringWriter tw = new System.IO.StringWriter();
        HtmlTextWriter hw = new HtmlTextWriter(tw);
        ctl.RenderControl(hw);
        HttpContext.Current.Response.Write(tw.ToString());
        HttpContext.Current.Response.End();
    }
    protected void imgBtnExport_Click(object sender, ImageClickEventArgs e)
    {
        gvAdditional.AllowPaging = false;
        Select();
        ToExcel(gvAdditional, "Report.xls");
        gvAdditional.AllowPaging = true;
    }
    //protected void btnExport_Click(object sender, EventArgs e)
    //{
    //    Response.Clear();
    //    Response.Buffer = true;
    //    Response.Charset = "utf-8";
    //    Response.AppendHeader("Content-Disposition", "attachment;filename=additional.xls");
    //    // 如果设置为 GetEncoding("GB2312");导出的文件将会出现乱码！！！
    //    Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
    //    Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。
    //    System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
    //    System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);

    //    gvAdditional.AllowPaging = false;
    //    Select();

    //    this.gvAdditional.RenderControl(oHtmlTextWriter);
    //    Response.Output.Write(oStringWriter.ToString());
    //    Response.Flush();
    //    Response.End();

    //    gvAdditional.AllowPaging = true;
    //    Select();
    //}
    public override void VerifyRenderingInServerForm(Control control)
    {
        //ConfirmsthatanHtmlFormcontrolisrenderedfor
    }