把GridView的列表数据导出为Execl表格文件

一、在aspx文件中，把Page命令中的属性EnableEventValidation设为false

 二、cs中的代码为：

        //override掉这个方法
        public override void VerifyRenderingInServerForm(Control control)
        {
            //注释掉下面的代码，否则在asp.net2.0下会报错（注：GridView是asp.net2.0下的控件，1.1下一些控件也可以导出成Excel或者Word）
            //base.VerifyRenderingInServerForm(control);
        }

        protected void btnToExcel_Click(object sender, EventArgs e)
        {
            Response.Clear();
            Response.BufferOutput = true;
            //设定输出的字符集
            Response.Charset = "GB2312";
            //假定导出的文件名为FileName.xls
            Response.AppendHeader("Content-Disposition", "attachment;filename=FileName.xls");
            Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
            //设置导出文件的格式
            Response.ContentType = "application/ms-excel";
            //关闭ViewState

            EnableViewState = false;
            System.Globalization.CultureInfo cultureInfo = new System.Globalization.CultureInfo("ZH-CN", true);
            System.IO.StringWriter stringWriter = new System.IO.StringWriter(cultureInfo);
            System.Web.UI.HtmlTextWriter textWriter = new System.Web.UI.HtmlTextWriter(stringWriter);
            gvList.RenderControl(textWriter);         //gvList为GridView控件ID
            //把HTML写回浏览器
            Response.Write(stringWriter.ToString());
            Response.End();
        }