GridView导出成Excel字符"0"丢失的处理方式代码,Asp.Net代码库,德仔网

代码语言

代码分类

【Asp.Net】 GridView导出成Excel字符"0"丢失的处理方式

作者:Dezai.CN / 发布于2013/2/20/ 669

CSS格式定义中有:td{mso-number-format:"\@";}.这样问题就容易解决了.

HttpContext.Current.Response.Clear();
        HttpContext.Current.Response.Buffer = true;
        HttpContext.Current.Response.Charset = "UTF-8";
        HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=WebOrderExcelFile.xls");
        HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8;
        HttpContext.Current.Response.ContentType = "application/ms-excel";
        string strStyle = "<style>td{mso-number-format:\"\\@\";}</style>";
        System.IO.StringWriter tw = new System.IO.StringWriter();
        HtmlTextWriter hw = new HtmlTextWriter(tw);
        gvOrder.Page.EnableViewState = false;
        tw.WriteLine(strStyle);
        gvOrder.RenderControl(hw);        
        HttpContext.Current.Response.Write(tw.ToString());
        HttpContext.Current.Response.Flush();
        HttpContext.Current.Response.End();

试试其它关键字

　字符"0"丢失　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)