ASP.NET中的GridView导出为EXCEL完整介绍

在将GridView导出为EXCEL时,有几个小技巧需要注意:

    1.  必须重载VerifyRenderingInServerForm函数

    public override void VerifyRenderingInServerForm(Control control)

    { }

   2. 导出函数如下:

         /// <summary>

        /// GridView导出为EXCEL

        /// </summary>

        /// <param >导出文件名</param>

        /// <param >gridview对象</param>

        /// <param >页对象</param>

        public static void ExportToExcel(string Filename, GridView gridview, Page page)

        {

            page.Response.ClearContent();

            page.Response.Buffer = true;

            page.Response.Charset = "";

            page.Response.AddHeader("content-disposition", "attachment; filename=" + System.Web.HttpUtility.UrlEncode(Filename, System.Text.Encoding.UTF8) + ".xls");

            page.Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");//设置输出流为简体中文

            page.Response.ContentType = "application/excel";

            page.EnableViewState = false;

            System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true);

            System.IO.StringWriter sw = new System.IO.StringWriter(myCItrad);

            System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw);

            gridview.RenderControl(htw);

            page.Response.Write(sw.ToString());

            page.Response.End();

        }

    函数引用:

    protected void ExcelButton_Click(object sender, EventArgs e)

    {

          DataSet ds = QueryDataDatas();

        if (ds == null)

            return;

        GridView2.DataSource = ds;

        GridView2.DataBind();

        ExportTo.ExportToExcel("Filename", GridView2, Page);

    }

   3. 如果含有类似于身份证这样的数据，在导出成为Excel后将变成科学计数法的形式显示，解决方法:可以通过以下方式进行转换，该段代码应写在RowDataBound事件中

    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)

    {

         if (e.Row.RowType == DataControlRowType.DataRow)

             e.Row.Cells[2].Attributes.Add("style", "vnd.ms-excel.numberformat:@");

    }