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:@");
    }