(转)导出EXCEL时科学计数法问题-白红宇

(转)导出EXCEL时科学计数法问题

阅读量：4929 次

发布时间：2019-06-11

本文共 1565 字，大约阅读时间需要 5 分钟。

//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%

HttpContext.Current.Response.Clear();            HttpContext.Current.Response.Charset = "";            HttpContext.Current.Response.ContentType = "application/vnd.ms-xls";            HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" + HttpUtility.UrlEncode(excelname + ".xls"));            StringBuilder table = new StringBuilder();            DataTable dt = ds.Tables[0];            table.Append("
     
        ");            for (int i = 0; i < dt.Columns.Count; i++)            {                table.Append("
");            }            table.Append("
");            for (int i = 0; i < dt.Rows.Count; i++)            {                table.Append("
        ");                for (int j = 0; j < dt.Columns.Count; j++)                {                    table.Append("
");                }                table.Append("
");            }            table.Append("
                     ");                table.Append(dt.Columns[i].Caption.ToString()); //标格的标题                table.Append("        
               ");                    table.Append(dt.Rows[i][j].ToString());                    table.Append("        
      
     
");            return table.ToString();            HttpContext.Current.Response.Write(table);            HttpContext.Current.Response.End();