0 Replies Latest reply on Oct 10, 2002 2:25 AM by 350503

    how to dump array created by 'getrows method' into spreadsheet??

      I'm sorry but I'm not goot as English.

      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.

      Please, Advice about my trying.