Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
chinese (UFT-8) in csv files created by a server
Hi
I have an online application written in PHP that exports database query reults to a CSV file to be saved on the user's local machine and opened by Excel when the output is UTF8 encoded and the CSV file is opened in notepad all the French accented charcaters and Chinese characters display fine. However, when i open the same file in Excel French accented charcaters and Chinese characters are wrong If I change the output encoding to latin, then the French characters display fine in Excel but not the Chinese ones. I tried opening a new Excel sheet, pasting in some chinese and saving it as csv format but the chinese just displayed as question marks - so this would seem to suggest that csv just won't accept UTF-8 encoding. So i turn to you as experts in all things Excel : do you know if csv has something inherent that will always prevent it from displaying chinese characters ? Or could there be some way to force the csv to accept this type of encoding ? thanks for any help you can give - even if it's just to tell me that what I want to do can't be done, so that i can find another approach to the problem thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
chinese (UFT-8) in csv files created by a server
it's ok I've cracked it using xml output to an xls file "Hugo Scott" wrote: Hi I have an online application written in PHP that exports database query reults to a CSV file to be saved on the user's local machine and opened by Excel when the output is UTF8 encoded and the CSV file is opened in notepad all the French accented charcaters and Chinese characters display fine. However, when i open the same file in Excel French accented charcaters and Chinese characters are wrong If I change the output encoding to latin, then the French characters display fine in Excel but not the Chinese ones. I tried opening a new Excel sheet, pasting in some chinese and saving it as csv format but the chinese just displayed as question marks - so this would seem to suggest that csv just won't accept UTF-8 encoding. So i turn to you as experts in all things Excel : do you know if csv has something inherent that will always prevent it from displaying chinese characters ? Or could there be some way to force the csv to accept this type of encoding ? thanks for any help you can give - even if it's just to tell me that what I want to do can't be done, so that i can find another approach to the problem thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 traditional chinese to simplified chinese | Excel Discussion (Misc queries) | |||
Chinese characters - UTF8 CSV files | Excel Programming | |||
Files Created By One Are Read-Only To Others | Excel Discussion (Misc queries) | |||
Data from Programmatically created Excel into SQL Server | Excel Programming | |||
Excel: help files in Chinese? | Excel Discussion (Misc queries) |