Get Table

Retrieves the first table data from a worksheet.

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

Example

outputVariable = GetTable(workbookPath="<workbookPath>", worksheetName="<worksheetName>", tableName="<tableName>")

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.

Outputs

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