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

解决方法1：将要导出的数据放到gridview里，邦定数据时进行字符串形式处理，然后再用普通的形式导出excel就把问题解决了。

protected void gError_RowDataBound(object sender, GridViewRowEventArgs e){
         //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%
        for (int i = 0; i < e.Row.Cells.Count; i++){
            if (e.Row.RowType == DataControlRowType.DataRow)
                e.Row.Cells[i ].Attributes.Add("style", "vnd.ms-excel.numberformat:@");
        }          
  }
  protected void btnOut_Click(object sender, EventArgs e){       
       Response.Clear();
       Response.Buffer = true;
        Response.Charset = "GB2312";
       Response.AppendHeader("Content-Disposition", "attachment;filename=FileName.xls");    
        Response.ContentEncoding = System.Text.Encoding.UTF7;
      Response.ContentType = "application/ms-excel";
       System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
       System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
       this.gError.RenderControl(oHtmlTextWriter);
        Response.Output.Write(oStringWriter.ToString());
        Response.Flush();
        Response.End();
    }
   public override void VerifyRenderingInServerForm(Control control){
    }

解决方法2：通过CSS

.txt {   
    padding-top:1px;
    padding-right:1px;
    padding-left:1px;
    mso-ignore:padding;
    color:black;
    font-size:11.0pt;
    font-weight:400;
    font-style:normal;
    text-decoration:none;
    font-family:宋体;
    mso-generic-font-family:auto;
    mso-font-charset:134;
    mso-number-format:"\@";
    text-align:general;
    vertical-align:middle;
    mso-background-source:auto;
    mso-pattern:auto;
    white-space:nowrap;
}