导出 设置单元格格式问题

 Montnets.Ceo.TPagination<SelfMsgHistory> T = (Montnets.Ceo.TPagination<SelfMsgHistory>)Session["data"];

        IList<SelfMsgHistory> list = T.RecordList;



        StringBuilder csv = new StringBuilder();

        csv.Append("接收人,内容,下发时间");

        csv.Append("\r\n");



        foreach (SelfMsgHistory sm in list)

        {

            //csv.Append("/@/");

            csv.Append(Util.GetCSVString(sm.Phones));

            csv.Append(Util.GetCSVString(sm.Message));

            csv.Append(Util.GetCSVString(sm.SendTime.ToString("yyyy-MM-dd hh:mm:ss")));

            csv.Append("\r\n");

        }

        if (list.Count > 1)

        {

            csv.Append("\r\n");

        }

        //Response.Clear();

        //Response.Buffer = true;

        //Response.Charset = "gb2312";

        //下面这行很重要， attachment 参数表示作为附件下载，您可以改成 online在线打开

        //filename=FileFlow.xls 指定输出文件的名称，注意其扩展名和指定文件类型相符，可以为：.doc  .xls  .txt 　.htm　　

        //Response.AppendHeader("Content-Disposition", "attachment;filename=\"" + Server.UrlEncode("已发自编短信") + ".csv\"");

        //Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");

        //style="vnd.ms-excel.numberformat:@"

        //Response.ContentType指定文件类型 可以为application/ms-excel 　 application/ms-word 　 application/ms-txt　 application/ms-html 　或其他浏览器可直接支持文档　

        //Response.ContentType = "application/ms-excel";



        //Response.Write(csv.ToString());

        //Response.End();

        //string style = @"<style> .text { mso-number-format:\@; } </script> ";

        //Response.Write(style); 

        //下面将文本输出为csv个数，可用excel直接打开

        Response.Clear();

        Response.Buffer = true;

        Response.Charset = "gb2312";

        //下面这行很重要， attachment 参数表示作为附件下载，您可以改成 online在线打开

        //filename=FileFlow.xls 指定输出文件的名称，注意其扩展名和指定文件类型相符，可以为：.doc  .xls  .txt 　.htm　　

        Response.AppendHeader("Content-Disposition", "attachment;filename=\"" + Server.UrlEncode("已发自编短信") + ".csv\"");

        Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");

        style="vnd.ms-excel.numberformat:@"

       // Response.ContentType指定文件类型 可以为application/ms-excel 　 application/ms-word 　 application/ms-txt　 application/ms-html 　或其他浏览器可直接支持文档　

        Response.ContentType = "application/ms-excel";

        this.EnableViewState = false;

        System.IO.StringWriter oStringWriter = new System.IO.StringWriter();

        oStringWriter.Write(csv.ToString());

        oStringWriter.Flush();

        System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);

        this.RenderControl(oHtmlTextWriter);

        //this 表示输出本页，你也可以绑定datagrid,或其他支持obj.RenderControl()属性的控件



        Response.Write(oStringWriter.ToString());

        Response.End();

     public static string GetCSVString(object value)

       {

           if (value == null) return ",";



           return value.ToString()

                        .Replace(',', '，')//替换,号

                        .Replace("\n", "\t")//替换换行

                        .Replace("\r", "\t")//替换换行

                        + ",";              //添加,号分隔符



       }