I'm trying to dump oo4o dynasets into farpoint spreadsheet without looping.
first, I created the array of variant type through the 'getrows' method of oo4o.
the 'getrows' method copies records from a Dynaset into a two-dimensional array. The first subscript identifies the field and the second identifies the row number.
Then I found the method 'setarray' of spreadsheet but this method dumps a array into spread
beginning with the row number. In result the spreadsheet views the recordset that the rows
and the columns are exchanged.