Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Example of Excel using VFP COM?
Message
 
 
To
14/10/1999 07:25:50
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00276233
Message ID:
00276668
Views:
26
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
Previous
Reply
Map
View

Click here to load this message in the networking platform