>Which method determines how many rows are in the spreadsheet? And how do you iterate through all rows?

Sorry for the late reply, sample code:

FOR lnRow=1 TO loExcel.GetLastRowNumber(lnWB, lnSheet)
     loRowData = loExcel.GetSheetRowValues(lnWB, lnSheet, lnRow)
     IF !ISNULL(loRowData)
          FOR lnCol=1 TO loRowData.Count
                  ? "Data Type: " + loRowData.List[lnCol, 2]
                  ? "Data Value: " + TRANSFORM(loRowData.List[lnCol, 1])
          ENDFOR
     ENDIF
ENDFOR