Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Grabbing a range in excel and putting it into a cursor i
Message
De
01/06/2007 14:51:45
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
01/06/2007 11:30:06
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Vista
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01229777
Message ID:
01229885
Vues:
7
>I have it workin with the clipboard.
>The only drawback is that stuff cames back as characters only. but other than tat it works fine
>
>Peter

Of course, you can also get the individual cells, with loSheet.Cells(lnRow, lnCol).Value.

It really depends a lot on the size of the range. I wouldn't worry about speed if you typically select a few pages, at most.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform