导出内容至Excel

   /// <summary>
        /// 导出内容至Excel
        /// </summary>
        /// <param name="ctl">需要获取内容的控件</param>
        /// <param name="FileName">Excel名称</param>
        public void ToExcel(System.Web.UI.Control ctl, string FileName)
        {
            HttpContext.Current.Response.Charset = "UTF-8";// 或UTF-7 以防乱码
            HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8;
            HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
            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);
            HttpContext.Current.Response.Write(tw.ToString());
            HttpContext.Current.Response.End();
            ctl.Page.EnableViewState = false;
        }

posted on 2017-12-01 16:32  New_q  阅读(126)  评论(0编辑  收藏  举报

导航