Selects a specified range from an Excel spreadsheet, in order to perform further actions. Can only be used in the Excel Application Scope activity.
Strings must be placed between quotation marks.
Range - The range to be selected. Only String variables and strings are supported.
SheetName - The name of the sheet from which to select the specified range. By default, this is filled in with "Sheet1." 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.
To exemplify how to use this activity, we have built an automation project which also includes a Select Range activity. The process opens an Excel workbook and displays the range specified by you. You can check the example here.
Updated about a year ago