Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Retrieving Cyrillic fields from Excel
Message
From
22/02/2001 16:11:50
 
 
To
22/02/2001 15:57:53
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00478013
Message ID:
00478623
Views:
30
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform