Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Exporting to CSV file with Chinese Characters in Spreadsheet
I received a file from one of our subsidiaries in Honk Kong. The spreadsheet
has Chinese characters in the spreadsheet that appear and print out just fine as Chinese characters. But when I export the data to a Comma Separated Value file, the Chinese characters all appear as question marks. I tried adding the Chinese language with the Windows XP SP2 CD but it did not make any difference. Any thoughts would be welcome. Thanks! Ron |
#2
|
|||
|
|||
Hi Ron,
I have a feeling that CSV files are always encoded as 8-bit and can't handle unicode text such as the Chinese alphabet. Can you export the data as HTML or XML for the purpose in question? Just a thought, Mark "Just Me" wrote: I received a file from one of our subsidiaries in Honk Kong. The spreadsheet has Chinese characters in the spreadsheet that appear and print out just fine as Chinese characters. But when I export the data to a Comma Separated Value file, the Chinese characters all appear as question marks. I tried adding the Chinese language with the Windows XP SP2 CD but it did not make any difference. Any thoughts would be welcome. Thanks! Ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exporting excel to text file | Excel Discussion (Misc queries) | |||
Exporting excel to text file | Excel Discussion (Misc queries) | |||
Exporting excel to text file | Excel Discussion (Misc queries) | |||
Exported File truncating cell data after 255 characters | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |