asp.net 导出excel

protected void btnExcel_Click(object sender, EventArgs e)
        {
            myDataGrid.AllowPaging = false;     //是否按分页的来显示 如果你不想第几列显示 也可以这设置 dvList.Columns[0].Visible = false;

 

      
            UpdateView();//给Grid赋值方法

            Response.ClearContent();
            Response.Charset = "UTF8";
            Response.ContentEncoding = System.Text.Encoding.UTF8;
            Response.AddHeader("content-disposition", "attachment; filename= " + HttpUtility.UrlEncode("收费分析列表.xls", Encoding.UTF8).ToString());

            Response.ContentType = "application/excel";

            StringWriter sw = new StringWriter();

            HtmlTextWriter htw = new HtmlTextWriter(sw);

 for (int i = 0; i < GridView1.Columns.Count; i++)
        {
            LinkButton linkButton = ((LinkButton)(GridView1.HeaderRow.Cells[i].Controls[0]));//获取标题行第i个单元格的<a>标签(LinkButton)
            string value = linkButton.Text;//保存<a>标签的文本
            GridView1.HeaderRow.Cells[i].Controls.Clear();//把标题行第i个单元格的所有控件删除(把<a>标签删除)
            GridView1.HeaderRow.Cells[i].Text = value;//把<a>标签的文本赋给标题行第i个单元格的文本
            linkButton.Dispose();
        }

            myDataGrid.RenderControl(htw);

            Response.Write(sw.ToString());

            Response.End();
        }

        public override void VerifyRenderingInServerForm(Control control)
        {

        }

页面page设置EnableEventValidation = "false"