Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Clipboard copying from excel
Message
 
À
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:
01519016
Vues:
50
You are absssssolutely right !!! Thank you soooooo very much!



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

If things have the tendency to go your way, do not worry. It won't last. Jules Renard.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform