Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Putting values in more than one excel-cell at a time
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Putting values in more than one excel-cell at a time
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01301740
Message ID:
01301740
Views:
53
Hello,

I try to create a general class that must read Excel-Data into a VFP-Cursor and vice versa.

It is no problem to do it on a cell-basis, but it is too slow, especially when putting the values into the sheet.

Is there any way to select a range in Excel and fill all the cells with the values in one step? E.g. to select a whole column as range and put the values from an array one in each cell?

Thanks
Alexander
Alexander Lerner
a_lerner@heinrich-schmid.de

The life is somewhat easier than it seems to be.
Next
Reply
Map
View

Click here to load this message in the networking platform