Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Clipboard copying from excel
Message
De
24/07/2011 05:33:48
 
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01518978
Message ID:
01519015
Vues:
129
This message has been marked as the solution to the initial question of the thread.
J'aime (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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform