Extracts the range of an Excel table from a specified spreadsheet. Can only be used in the Excel Application Scope activity.
Strings must be placed between quotation marks.
TableName - The name of the table for which to get the range. Only String variables and strings are supported.
SheetName - The name of the sheet from which to get the range. By default, this is filled in with "Sheet1." Only String variables are supported.
- IsPivot - When selected, this option indicates that the specified table is a pivot one. By default, this check box is not selected.
- Range - The range of the specified table. Only String variables and strings are supported.
- DisplayName - The display name of the activity.
- Private - If selected, the values of variables and arguments are no longer logged at Verbose level.
You can see how the Get Table Range activity is used in an example that incorporates multiple activities.
To exemplify how to use this activity, we have built an automation project which also includes a Get Table Range activity.
You can check and download the example from here
Updated 9 months ago