HTML to Excel : mso-number-format style attribute

 

테이블 Cell(<td>)에 사용할 수 있는 mso-number-format style attribute입니다.

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)


[CSS style sheet]
td.accountnum
  {mso-number-format:\@}

[Attribute]
 <td class="accountnum">01070000<td>

 


출처 : http://www.bywoong.com/38

댓글
  • No Nickname
    No Comment
  • 권한이 없습니다.
    {{m_row.m_nick}}
    -
목록형 📷 갤러리형
제목
[기본형] HTML (with 부트스트랩5.3 , jquery 3.7, vue.js)
유용한 리눅스(LINUX) 명령어
[공지] 기술 게시판
3.31
4.1
4.2
4.3
4.4
4.5
4.6
4.7
4.8
4.10
4.11
4.12
4.13
4.14
4.15
4.16
4.18
4.19
4.20
4.21
4.22
4.23
4.24
4.25
4.26
4.27
4.28
4.29
4.30
5.1
5.2
5.3
5.4