Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Retrieving Cyrillic fields from Excel
Message
De
22/02/2001 16:11:50
 
 
À
22/02/2001 15:57:53
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00478013
Message ID:
00478623
Vues:
27
>Yes, in Excel cyrillic fields display just fine. I can even copy/paste
>them form Excel to Word and Outlook via ctrl+c/ctl+v.
>
>>>I've an Excel sheet that contains russian text fields which need
>>>to be imported into a VFP table. Whenever I try to fetch a value
>>>from a cyrillic field I just get a string of question marks. The
>>>number of question marks corresponds to the length of the field
>>>value.
>>>
>>>This is the code line that retrieves the value
>>>
>>>cFld = oExcel.Range("A1:A1").Value
>>>
>>>
>>>First I thought I had selected a font that couldn't display Russian
>>>characters, but checking the result string with ASC() shows that it only contains a set of 63s ('?').
>>>I'm obviously missing something here.
>>
>>What happens if you open that spreadsheet in Excel? Can you see text in it?
>>Mark
I will try to check what is a defaut font FOX uses for its environment and if that font is not capable of showing cyrillic fonts change to one which it is.
Mark
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform