Get Table Row

Returns a table row from an Office 365 / Excel workbook.

Category: Microsoft Office 365 & OneDrive · Group: Office 365 · Activity name: GetTableRow

Example

outputVariable = GetTableRow(workbookPath="<workbookPath>", worksheetName="<worksheetName>", tableName="<tableName>", index=0)

Inputs

Name	Type	Required	Default	Description
Workbook Path	string			Workbook path.
Worksheet Name	string			Worksheet Name.
Table Name	string			The name of the table for which to get rows count. If not specified, it is using the first available table.
Index	integer			The row number as specified in excel.

Outputs

Name	Type	Description
outputVariable	array	Specifies the name of the variable that will store the table row data.