HTML导出Excel数据类型转换样式参考

mso-number-format:"0"    NO Decimals  
mso-number-format:"0/.000"    3 Decimals  
mso-number-format:"/#/,/#/#0/.000"    Comma with 3 dec  
mso-number-format:"mm//dd//yy"    Date7  
mso-number-format:"mmmm/ d/,/ yyyy"    Date9  
mso-number-format:"m//d//yy/ h/:mm/ AM//PM"    D -T AMPM  
mso-number-format:"Short Date"    01/03/1998  
mso-number-format:"Medium Date"    01-mar-98  
mso-number-format:"d/-mmm/-yyyy"    01-mar-1998  
mso-number-format:"Short Time"    5:16  
mso-number-format:"Medium Time"    5:16 am  
mso-number-format:"Long Time"    5:16:21:00  
mso-number-format:"Percent"    Percent - two decimals  
mso-number-format:"0%"    Percent - no decimals  
mso-number-format:"0/.E+00"    Scientific Notation  
mso-number-format:"/@"    Text  
mso-number-format:"/#/ ???//???"    Fractions - up to 3 digits (312/943)  
mso-number-format:"/0022£/0022/#/,/#/#0/.00"    £12.76  
mso-number-format:"/#/,/#/#0/.00_ /;/[Red/]/-/#/,/#/#0/.00/ "      
2 decimals, negative numbers in red and signed  
(1.56   -1.56)  

  

posted @ 2017-12-07 10:34  猫头老鹰  阅读(552)  评论(0编辑  收藏  举报