The exported Excel ID card is too long, leading to abnormal display of the custom cell format Solution

Html Code : View code

 <  Html  >   <  Head  >   </  Head  >   <  Body  >   <  Table >   <  Tr  >   <  TD  > 1 </  TD  >   <  TD  Style  = "MSO-number-format :'/@';"  > 10000000000001 </  TD >   <  TD  Style  = "MSO-number-format: '0/. 00 ';"  > 111111111111111 </  TD  >   </  Tr  >   <  Tr  >   <  TD > 1 </  TD  >   <  TD  > 10000000000001 </  TD  >   <  TD  > 11111111111111111111 </  TD  >  </  Tr  >   </  Table  >   </  Body  >   </  Html  > 

 

The main function is <TD style = "MSO-number-format: '\ @';">

Other custom cell format styles

 

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 £0. 00"	£12. 76
MSO-number-format: "\#\,\#\# 0 \. 00 _ \; \ [red \] \-\#\, \#\# 0 \. 00 \"	2 decimals, negative numbers in red and signed (1.56-1.56)