Definition and Usage
This command activates a specified worksheet in an Excel file. It allows you to switch between different worksheets in an open Excel workbook by selecting either the worksheet name or its index position.
Parameter Values
Input parameters
Parameter | Description | Possible Values | Required | Options / Notes |
Excel instance | Select an Excel instance to identify the instance to operate on |
| Yes | Must be created via "Launch Excel" or "Get active Excel worksheet" command |
Selection method | Choose how to select the worksheet | By worksheet name, By worksheet index | Yes |
|
Worksheet name | Enter the name of the worksheet to select |
| Yes (if selecting by name) |
|
Worksheet index | Enter the position of the worksheet (starting from 1) |
| Yes (if selecting by index) |
|
Error handling
Parameter Name | Description |
Throw error & stop | When an error occurs, the action will trigger an error and stop the execution of the entire app. |
Retry command | If an error occurs, the action will retry the command in an attempt to resolve the issue and continue the process. |
Ignore error & continue | When an error occurs, the action will be ignored, and the workflow will continue without interruption. |
Variables produced
This action doesn't produce any variables.
Using Variables in Conditions
You can use variables in the worksheet name or worksheet index fields by clicking the {x} icon. This allows you to dynamically select worksheets based on values determined during workflow execution. Ensure that the variable type matches the expected input type - text for worksheet name and number for worksheet index.
Notes
Before using this command, ensure that a valid Excel instance has been created and the target file is open.
If the specified worksheet name or index cannot be found, the command will result in an error.
Worksheet index starts from 1, with the leftmost tab in the Excel file being 1.
When selecting by name, the worksheet name is case-sensitive and must match exactly.