Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Retrieving Cyrillic fields from Excel
Message
From
23/02/2001 06:29:20
 
 
To
22/02/2001 16:11:50
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00478013
Message ID:
00478741
Views:
37
It isn't a font thing. I have the Windows Russian keyboard layout
installed and when I switch to it, I can type in Russian in the VFP
command window (if the currently selected font supports
cyrillic characters). However, any russian field from Excel comes
over as a string of question marks. The same string,
when pasted into a Word document using the same font as my VFP's
command window (Courier New), displays correctly.



>>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