Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Example of Excel using VFP COM?
Message
 
 
À
14/10/1999 07:25:50
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00276233
Message ID:
00276668
Vues:
25
Tom,

I think you'll get the best speed by simply using a COPY TO TYPE XLS. Automating Excel and filling cells is horridly slow. Once the file is out there you can crank up Excel and have it open the file.

>In the past I have used VFP to control and populate
>cells in an Excel spreadsheet.
>
>Would it be faster to create a VFP table, invoke
>Excel and have the COM object load the data to the
>spreadsheet? I do not use Excel much, so I don't
>even know where to put the COM object and kick it off.
>Does anyone have an example of such an animal?
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform