Definition and Usage
Retrieve the currently active worksheet from an open Excel instance. This command allows you to access the worksheet that is currently in focus within Excel, making it available for further operations in your workflow.
Note: This command must be used with a Launch Excel command.
Parameter Values
Input parameters
This action does not require any input parameters.
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 command produces an output variable that stores the Excel instance, allowing you to reference the active worksheet in subsequent actions.
Using Variables in Conditions
When working with the output variable from this command, you can use it in subsequent Excel operations that require a worksheet reference. The variable can be inserted into parameters of other commands by using the variable selector (indicated by {x} icon).
Notes
Before using this command, ensure that an Excel application is open and a worksheet is active.
If no Excel instance is running or no worksheet is active, the command will result in an error.
This command only retrieves the active worksheet; it does not change which worksheet is active.
The retrieved worksheet object can be used for various operations such as reading data, writing data, or modifying worksheet properties.