Topic: How import cyrillic character data from Excel file ?

[Vandyck]

I use the wonderful GetExcel.lsp library by Terry Miller to read data from Excel file.

But, when data are coded in cyrillic characters VisualLisp don't support Unicode , the result is "? ? ? ?" strings

See the attached file
"test_unicode.xls", where A1 cell is in cyrillic char, B1 cell is normal text (for me).
and try: (GetExcel "C:\\test_unicode.xls" "Sheet1" "A1") => (("? ? ? ? ?"))

Some ideas ? (I think to export data in unicode .txt file...)
GetExcel.lsp is here: http://web2.airmail.net/terrycad/LISP/GetExcel.lsp

[NICK_VNV]

I've got (GetExcel "e:\\test_unicode.xls" "Sheet1" "A1") ==> (("ПАЛЕЦ"))
seems problem is somwhere else

[roy_043]

Maybe the font used for the command window is causing the problem.

[NICK_VNV]

Maybe the font used for the command window is causing the problem.

Try to paste result as text to model to check it:

Code: [Select]

(command "_text" (getpoint) 3 0 (caar(GetExcel "c:\\test_unicode.xls" "sheet1" "a1")))


[Vandyck]

thank you for the answers

if I copy&paste the "ПАЛЕЦ" string in the graphics area I get an correct entity TEXT string.

But the problem is in VLISP... he does not seem to manage this data

I use Window7 64bit, Autocad 2013 and the code page (getvar "syscodepage") is "ANSI_1252".
maybe it's something related to system codepage ? Uhmmm... but, for example , when I paste "ПАЛЕЦ" in NOTEPAD the text is ok.

Nick_VNV, which codepage have you?

[NICK_VNV]

I use Window7 64bit, Autocad 2013 and the code page (getvar "syscodepage") is "ANSI_1252".
....
Nick_VNV, which codepage have you?

I have ANSI_1251.
ANSI_1252 is not cyrillic(!) See difference on https://ru.wikipedia.org/wiki/ISO_8859-1 and https://ru.wikipedia.org/wiki/Windows-1251.
Maybe you have installed Autocad with incorrect language?