반응형
Response.ContentType="application/vnd.ms-excel"
Response.CacheControl = "public"
Response.AddHeader "Content-Disposition", "attachment;filename=map.xls"
참조사이트http://agoric.com/sources/software/htmltoExcel
- mso-number-format:\@
- text
- mso-number-format:"0\.000"
- 3 decimals
- mso-number-format:\#\,\#\#0\.000
- comma separators (and 3 decimals)
- mso-number-format:"mm\/dd\/yy"
- Date format
- mso-number-format:"d\\-mmm\\-yyyy"
- another date format
- mso-number-format:Percent
- percent
td.accountnum
{mso-number-format:\@}
br
{mso-data-placement:same-cell;}
<td class="accountnum">01070000<td>