>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
Yes, and you need to show top-left cell's address as starting point for insertion. In a template you might name (define name) a range as a location to insert data and refer to that range by name (oExcel.ActiveWorkBook.ActiveSheet.Range("myDataLocation").
Check
Re: Exporting to Excel Thread #
1278127 Message #
1278137IMHO to and from excel ADO is best approach.
Cetin