将gridview导出到Excel

/**//// <summary>
    /// 将gridview导出到Excel
    /// </summary>
    #region
    protected void ToExcel()
    {
        //屏蔽掉不需要导出的列
        gvList.Columns[0].Visible = false;
        gvList.Columns[2].Visible = false;
        gvList.Columns[6].Visible = false;
        gvList.Columns[7].Visible = false;
        gvList.Columns[9].Visible = false;
        gvList.Columns[10].Visible = false;
        gvList.Columns[11].Visible = false;
        gvList.Columns[13].Visible = false;
        
       //导出
        string FileName = "test";
        Response.Clear();

        Response.AddHeader("content-disposition",
        "attachment;filename="+FileName+".xls");

        Response.Charset = "gb2312";
        Response.ContentType = "application/vnd.xls";

        System.IO.StringWriter stringWrite = new System.IO.StringWriter();

        System.Web.UI.HtmlTextWriter htmlWrite =
        new HtmlTextWriter(stringWrite);


        gvList.AllowPaging = false;
        ListGridViewDataBind();
        gvList.RenderControl(htmlWrite);

        Response.Write(stringWrite.ToString());

        Response.End();

        gvList.AllowPaging = true;
        ListGridViewDataBind();



    }
    public override void VerifyRenderingInServerForm(Control control)
    {

        // Confirms that an HtmlForm control is rendered for

    }
    protected void paging(object sender, GridViewPageEventArgs e)
    {
        gvList.PageIndex = e.NewPageIndex;
        ListGridViewDataBind();
    }
      protected void gvList_RowDataBound( object sender, GridViewRowEventArgs e )
  {
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
      e.Row.Cells[1].Attributes.Add("style", "vnd.ms-excel.numberformat:@;");
    }
  }

    #endregion

需要注意的是要在页面中加入红色部分,这样才不会报错
<%@ Page Language="C#" EnableEventValidation="false" MasterPageFile="~/site.master"
    AutoEventWireup="true" CodeFile="WorkList.aspx.cs" Inherits="TspSystem_DemandManagerModule_WorkList"
    Title="Untitled Page" %>