본문 바로가기
컴퓨터이야기/ASP&.NET

Excel 변환

by 변화지시자 2009. 11. 21.
반응형

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>