Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Automating Excel extracting russian characters from cell
Message
De
16/09/2011 04:12:55
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
01523701
Message ID:
01523705
Vues:
71
For some reason both calls give me
Function argument value, type, or count is invalid (Error 11)
when running.

Maybe because osheet.Cells(i,j).value is not proper value already as it is shown in watch window or tooltip as "???????"

>>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform