asp.net导出excel及科学计数问题

最新推荐文章于 2025-08-16 22:13:48 发布

转载最新推荐文章于 2025-08-16 22:13:48 发布 · 55 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/littlebird/archive/2009/07/28/1533087.html

文章标签：

#ui

本文介绍了一种使用 ASP.NET 进行 Excel 导出的方法，重点在于如何防止数字列被 Excel 识别为科学计数法，通过设置单元格属性实现了正确的格式显示。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

转自：http://www.cnblogs.com/legend_sun/archive/2009/02/17/1392493.html

导出最简单方法：

const string style = @"<style> .text { mso-number-format:\@; } </style> " ;
            Response.ClearContent();

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

            Response.ContentType = "application/excel" ;

            StringWriter sw = new StringWriter();

            HtmlTextWriter htw = new HtmlTextWriter(sw);
            //htw.WriteLine(Name);
            System.Web.UI.LiteralControl lt = new LiteralControl();
            lt.Text = "<div style=\"width:100%;font-bold:true;text-align:center;\">" +Name + "</div>" ;
            if(Name!="" )lt.RenderControl(htw);
            gvdata.RenderControl(htw);
            // Style is added dynamically

            Response.Write(style);

            Response.Write(sw.ToString());

            Response.End();

导出出现科学计数解决办法一：

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 = dtData;
                gvdata.DataBind();
                const string style = @"<style> .text {mso-number-format:\@; } </style> " ;
                Response.ClearContent();

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

                Response.ContentType = "application/excel" ;

                StringWriter sw = new StringWriter();

                HtmlTextWriter htw = new HtmlTextWriter(sw);
                //htw.WriteLine(Name);
                System.Web.UI.LiteralControl lt = new LiteralControl();
                lt.Text = "<div style=\"width:100%;font-bold:true;text-align:center;\">" + strFileName + "</div>" ;
                if (strFileName != "" ) lt.RenderControl(htw);
                gvdata.RenderControl(htw);
                // Style is added dynamically

                Response.Write(style);

                Response.Write(sw.ToString());

                Response.End();
     public void gvdataRowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            e.Row.Cells[0].Attributes.Add("style", "vnd.ms-excel.numberformat:@" );
            e.Row.Cells[2].Attributes.Add("style", "vnd.ms-excel.numberformat:@" );
        }
    }

另注： // 1）文本：vnd.ms-excel.numberformat:@
          // 2）日期：vnd.ms-excel.numberformat:yyyy/mm/dd
         // 3）数字：vnd.ms-excel.numberformat:#,##0.00
         // 4）货币：vnd.ms-excel.numberformat:￥#,##0.00
         // 5）百分比：vnd.ms-excel.numberformat: #0.00%

转载于:https://www.cnblogs.com/littlebird/archive/2009/07/28/1533087.html