Get Table Range

This activity allows the user to retrieve the range of a table or pivot table from a specified Excel sheet. It must be used within the “Excel Scope” activity.

Properties

INPUT

Sheet Name: *Specify the sheet name from which the table range should be retrieved, and it accepts values in String datatype, either hardcode the value or assign it to a variable of the String datatype.

Table Name: *Specify the name of the table to extract the range and it accepts values in String datatype, either hardcode the value or assign it to a variable of the String datatype.

OPTIONS 

IsPivot: This parameter lets you specify if the table is a pivot table. By default, this option is not selected.

MISC

DisplayName: Displays the name of the activity. The activity name can be customized, which aids in troubleshooting.

SkipOnError: Specify the “Boolean” value as “True” or “False.”
True: Continue executing the workflow regardless of any errors thrown.
False: Halt the workflow if it encounters any errors.
None: If the option is left blank, the activity will, by default, behave as if “False” were chosen.

Version: It indicates the version of the feature being used.

OUTPUT

Range: It provides the result of the range retrieved from the specified sheet and returns values in “String” datatype. 

Result: This parameter allows you to view the execution status of the activity and returns a value in “Boolean.”
True: Indicates that the activity has been executed successfully without any errors.
False: Indicates that the activity has been unsuccessful due to an unexpected error being thrown.

* Represents mandatory fields to execute the workflow