Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Automating Excel extracting russian characters from cell
Message
 
À
16/09/2011 03:09:58
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
01523701
Message ID:
01523702
Vues:
82
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform