Definition and Usage
Delete Excel image command allows you to remove all images or images located in a specified cell within an Excel worksheet. This command is useful for cleaning up worksheets by removing unnecessary images either from a specific location or throughout the entire worksheet.
Parameter Values
Input parameters
Parameter | Description | Possible Values | Required | Options / Notes |
Excel instance | Please select an Excel instance to identify the instance to operate on | - | Yes | Must be created via the "Launch Excel" or "Get active Excel worksheet" command |
Worksheet name | Specify the worksheet name | - | No | Leave blank for the active worksheet |
Image scope | Choose the scope of images to delete | Specified cell, All images | Yes | - |
Row | Specify the row number of the target cell | - | Yes (if "Specified cell" is selected) | Use 1 for the first row, or -1 for the last row |
Column | Specify the column of the target cell | - | Yes (if "Specified cell" is selected) | Use either a number (1 = first, -1 = last) or a letter (e.g., A, B, C) |
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
When configuring this action, parameters marked with {x} support the use of variables. You can insert previously defined variables by clicking on the field and selecting a variable from the dropdown menu. This is particularly useful when you need to dynamically specify worksheet names or cell references based on values determined during workflow execution.
Notes
Before using this command, ensure that a valid Excel instance has been created and is active.
The "All images" option will delete all images in the specified worksheet, while "Specified cell" will only delete images anchored to that particular cell.
When specifying a cell location, you can use either absolute values or variables to determine the row and column.
If the specified worksheet cannot be found or if there are no images to delete, the command may generate an error based on your error handling settings.