>>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
>
>
>
>
>Good Luck
Thank you!
I don't understand why, but it really works...
Alexander