Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update multiple Excel cells
Message
From
13/03/2000 16:16:38
 
 
To
13/03/2000 16:02:02
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00345130
Message ID:
00345140
Views:
22
I'm can't recall the specifics, but I recall a discussion that copying the data to the clipboard using _cliptext and paste while in Excel.

PF

>I have been working on updating an Excel spreadsheet with data from VFP 6. I can do all of the basic processes, but the way I am updating is very slow. I am currently using oleapp.range("A1").value=somevalue then oleapp.range("A2").value=anothervalue and so on. Some of these processes involve a large amount of data. Is there a way to select a range of cells and update them all from an array or other source that would improve the performance?
>
>Thanks in advance for any suggestions.

(On an infant's shirt): Already smarter than Bush
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform