Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use META tag to specify the charset on a HTML table, all cells are treated as text in Excel 2003
I am using Response.ContentType = "application/vnd.ms-excel" to export
a html table (actually it's a grid with headers and data) to excel. To get the double byte header text (such as Chinese or Japanese) show up correctly, I have to specify the charset in the html documentation by using the META tag. <HEAD<META http-equiv="Content-Type" content="text/html;charset=GB2312" /</HEAD By doing that, all the cells in the html table are treated as text in Excel 2003. As a result, the number format and the formula on the data cells are messed up. Does anyone has seen this? Please share your insight if you have a solution. Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When is text treated as number? | Excel Discussion (Misc queries) | |||
Pasted HTML Table Data Won't Convert From Text | Excel Discussion (Misc queries) | |||
Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
Formula Being treated as Text | Excel Worksheet Functions | |||
Help: HTML Table not displaying full text | Excel Programming |