SetRowSetData method: PSSpreadsheet class

Syntax

SetRowSetData(&rowset)

Description

Use the SetRowSetData method to read the data from a standalone rowset into the spreadsheet.

Parameters

Parameter	Description
&rowset	Specifies an already instantiated standalone Rowset object.

Returns

(Optional) A Boolean value: True if the method completes successfully, False otherwise.

Example

The following example sets the PeopleSoft rowset data into the spreadsheet.

Local number &idx = 1;

Local Rowset &rs;
&rs = CreateRowset(Record.MY_DATA_TBL);
Local integer &rowNum, &colNum, &cellType;
Local string &cellData;

While (&qSQL.Fetch(&rowNum, &colNum, &cellType, &cellData))
   If &idx <> 1 Then
      &rs.InsertRow(&rs.ActiveRowCount);
   End-If;
   &rs(&idx).MY_DATA_TBL.ROWNUM.Value = &rowNum;
   &rs(&idx).MY_DATA_TBL.COLNUM.Value = &colNum;
   &rs(&idx).MY_DATA_TBL.CELLDATA.Value = &cellData;
   &rs(&idx).MY_DATA_TBL.CELLTYPE.Value = &cellType;
   &idx = &idx + 1;
End-While;

&ssObject.SetRowSetData(&rs);