Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Clipboard copying from excel
Message
From
24/07/2011 05:33:48
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01518978
Message ID:
01519015
Views:
128
This message has been marked as the solution to the initial question of the thread.
Likes (1)
Marc,

There is no need to write anything
local aa[1]
aa = m.o.range("myRange").Value
?alen(aa, 1)
?alen(aa, 2)

&& look at aa in the debugger - all the values are there - you've got  the array you asked for
>Thank you very much Gregory.
>
>The advantage of using the Clipboard is performance. The copy function dumps the range into a string in vfp, the cells are separated by tabs (Ascii 9) (not checked how rows are separated, but that's easy to find out). Was just hoping someone had already written a function that de-compiles that.
>
>Take care and kind regards,
>
>Marc
>
Gregory
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform