Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Automating Excel extracting russian characters from cell
Message
 
To
16/09/2011 03:09:58
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01523701
Message ID:
01523702
Views:
80
>I converted pdf table to excel format ( Office 2010 ) with ABBYY pdf transformer and try to generate xml file via Excel automation.
>
>All Russian and Belorussian names properly seen in Excel
>РУБИНОВ Анатолий Николаевич
>Рубінаў Анатоль Мікалаевіч
>
>But after this statement
>
>lcell_value = osheet.Cells(i,j ).value
>
>in Foxpro they are just sequences of "?". I tried to play with strconv , but didn't find a proper combination. My understanding in Excel it is UTF-16, and in xml we should end up with utf-8.

Did you try ?
?strconv(osheet.Cells(i,j ).value,2,1251,1)
?strconv(osheet.Cells(i,j ).value,2,204,2)
MartinaJ
"Navision is evil that needs to be erazed... to the ground"

Jabber: gorila@dione.zcu.cz
Jabber? Jabbim
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform