asp.net DataTable 导出Excel 去除科学计数法

代码：

View Code

        /// <summary>
        /// 生成Excel
        /// </summary>
        /// <param name="page"></param>
        /// <param name="pDataTable">数据表</param>
        /// <param name="pUserID">文件名</param>
        public void CreateExcel(System.Web.UI.Page page, DataTable dt, string FileName)
        {
            HttpResponse resp;
            resp = page.Response;
            //resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
            resp.ContentType = "application/vnd.ms-excel";
            resp.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
            resp.Charset = "GB2312";

            resp.AddHeader("Content-Disposition", "attachment; filename=" + System.Web.HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8) + ".xls");
            GridView gvdata = new GridView();
            gvdata.HeaderStyle.BackColor = System.Drawing.Color.Silver;
            gvdata.HeaderStyle.Font.Bold = true;
            gvdata.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
            gvdata.RowDataBound += new GridViewRowEventHandler(gvdataRowDataBound);
            gvdata.DataSource = dt;
            gvdata.DataBind();
            const string style = @"<style> .text {mso-number-format:\@; } </style> ";
            resp.ClearContent();
            StringWriter sw = new StringWriter();
            HtmlTextWriter htw = new HtmlTextWriter(sw);
                      resp.Write("<meta http-equiv=\"content-type\" content=\"application/ms-excel; charset=gb2312\"/>" + style + sw.ToString());

            //写缓冲区中的数据到HTTP头文件中
            resp.End();
        }

 

 

转载于:https://www.cnblogs.com/JL1983/archive/2013/03/28/2987012.html