关于页面的数据导出到Excel

          很久没有来写心得了，最近用到了将页面的数据导出到EXCEL，于是就在网上找了一下，发现代码还挺多的，赋值过来修改一下差不多就可以用了。为了自己用户更方便，于是将另存一份。

/// <summary>
        /// 导出数据到Excel;
        /// </summary>
        private void ExportDataToExcel()
        {
            Response.Clear();
            Response.Buffer = true;
            Response.Charset = "GB2312";
            Response.AppendHeader("Content-Disposition", "attachment;filename=FileName.xls");
            Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
            //设置输出流为简体中文  
            Response.ContentType = "application/ms-excel";
            //设置输出文件类型为excel文件。  
            this.EnableViewState = false;
            System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true);
            System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
            System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
            this.gv_userList.RenderControl(oHtmlTextWriter);
                       
            Response.Write(oStringWriter.ToString());
            Response.End();
        }

如果是用在模板页中可能会出现，一些错误，比如：缺少runat=server

这个时候需要重载一下

 public override void VerifyRenderingInServerForm(Control control)
        {
          
        }