将DataGrid 的数据导到Excel

 

    将DataGrid 的数据导到 Excel#region 将DataGrid 的数据导到 Excel
    /**//// <summary>
    /// 
    /// </summary>
    /// <param name="ctl">DataGrid</param>
    /// <param name="FileName">保存的文件名称</param>
    public static void ToExcel(System.Web.UI.Control ctl, string FileName)
    {
        System.Web.HttpContext.Current.Response.Charset = "UTF-8";
        System.Web.HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Default;
        System.Web.HttpContext.Current.Response.ContentType = "application/ms-excel";
        System.Web.HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + "" + FileName + ".xls");
        ctl.Page.EnableViewState = false;
        System.IO.StringWriter tw = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
        ctl.RenderControl(hw);
        System.Web.HttpContext.Current.Response.Write(tw.ToString());
        System.Web.HttpContext.Current.Response.End();
    }
    #endregion

调用（如：button1）
    protected void button1_Click(object sender, EventArgs e)
    {
        ToExcel(this.dd, "excel");
    }