Definition and Usage
This command deletes a specified Excel worksheet from a workbook. You can either delete the active worksheet or specify a worksheet name to be deleted.
Parameter Values
Input parameters
Parameter | Description | Required | Options / Notes |
Excel instance | Please select an Excel instance (created via the "Launch Excel" or "Get active Excel worksheet" command) to identify the instance to operate on. | Yes | Must reference a valid Excel instance |
Worksheet name | Enter the worksheet name to delete (leave blank to delete the active worksheet) | No | If left blank, the currently active worksheet will be deleted |
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 parameters of this command by clicking the variable icon or typing {x} where x is your variable name. This allows you to dynamically specify worksheet names based on previously defined variables in your workflow.
Notes
Before using this command, ensure that a valid Excel instance has been created through "Launch Excel" or "Get active Excel worksheet" commands.
Excel workbooks must have at least one worksheet; attempting to delete the last remaining worksheet will result in an error.
Be cautious when deleting worksheets as the operation cannot be undone within the RPA workflow.
If the specified worksheet name does not exist, the command will generate an error.