java导出excel 科学计数法_导出EXCEL时科学计数法问题 （转）

//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(dt.Columns[i].Caption.ToString()); //标格的标题

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(dt.Rows[i][j].ToString());

table.Append("

");

}

table.Append("

");

}

table.Append("

");

return table.ToString();

HttpContext.Current.Response.Write(table);

HttpContext.Current.Response.End();

原文：http://www.cnblogs.com/JsonShare/p/4872173.html