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
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01301740
Message ID:
01301743
Views:
8
>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

Sure:
Dimension Array2Excel(i,j)
* populate array as needed, make sure that its dimensions are the same as
 *the range you need to fill in

.....
oExcel.Range(...).Value = ArrayPasser("Array2Excel") 
.....
*--------------------------------------------
Procedure ArrayPasser 
Lparameters lcArrayName 
Return @&lcArrayName    && for VFP7 and above
Good Luck
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform