read chinese characters from excel
I do have an german Windows OS, an german BricsCAD V18 an an german office2010. Now i got an excel file with chinese characters in it. If i open the excel file, i got shown the chinese characters well. I can copy them by clipboard an paste in BricsCAD as mtext and they are displayed as well.
Now i like to read the text directly from excel by using vlisp. Every text now is in ????? (questionmarks)
Now my question is:
which of the Programs need to swiched to the chinese language? Do i need to swich Windows to chinese or Office or both?
I dont think there is an option to read the right characters only by formating the cells to other values
Thanks
Martin
Comments
-
You should first verify if this is not a font issue. Try using vl-string->list.
0 -
You are right, Roy, but this i verified bevore. And yes all characters are 63 -> ?
0 -
Ok i solved it. It's only an codepage isue. if you change the language settings of windows to chinese, visualLisp will read the characters on the right way.
0 -
FYI: Using 'ADO' I experience no issues reading an .xlsx file with Chinese characters.
0
