解决C# 导出gridview中的数据到excel 时, 全数字时 0 被去掉的问题

最新推荐文章于 2024-04-23 10:05:26 发布

原创最新推荐文章于 2024-04-23 10:05:26 发布 · 1.3k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#excel #c# #string

本文介绍了一个C#解决方案，用于将GridView数据导出到Excel时确保全数字列保持其前导0。通过设置`mso-number-format`样式为`'@'`，可以防止数字格式化导致的0被自动去掉。

System.IO.StringWriter tw = new System.IO.StringWriter();
                System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
                GridView gv = new GridView();
                gv.EnableViewState = false;
                gv.DataSource = tbl;
                gv.DataBind();
                gv.RenderControl(hw);

                string style = @"<style type=""text/css"">td{mso-number-format:'\@';}</style>";

                HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename="+DateTime.Now.ToFileTime()+".xls");
                HttpContext.Current.Response.Charset = "UTF-8";
                HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Default;
                HttpContext.Current.Response.ContentType = "application/ms-excel";
                Response.Output.Write(style);
                Response.Write(tw.ToString());
                Response.Flush();
                Response.End();