Definition and Usage
The Export image from cell command exports an image that is either floating above or embedded in a specified Excel cell. You can define the target worksheet, row, and column, and save the extracted image to a chosen folder. The file path of the exported image can be stored in a variable for later use.
Notice!
In Excel, only floating images above the worksheet can be exported.
In WPS spreadsheets, both floating and embedded images can be exported.
Parameter Values
Input Parameters
Parameter Name | Description | Possible Values | Required | Options / Notes |
Excel instance | Select an Excel instance created with Launch Excel or Get active Excel worksheet. | Any valid Excel instance | Yes | Ensure the instance is running and accessible. |
Worksheet name | Specify the worksheet name. Leave blank to use the active worksheet. | Any worksheet name; blank | No | Useful if the workbook has multiple worksheets. |
Row | Specify the row number of the target cell. | Positive or negative number | Yes | e.g. Use 1 for the first row, -1 for the last. |
Column | Specify the column as a number | Number or letter | Yes | Column index must follow Excel convention. |
Save image to | Select the folder where the extracted images will be saved. | Any valid folder path | Yes | Ensure the folder exists and is writable. |
Error Handling
Parameter Name | Description |
Throw error & stop | When an error occurs, the action will stop execution. |
Retry command | The action retries the command if an error occurs. |
Ignore error & continue | The action ignores the error and continues workflow execution. |
Variables Produced
Variable Name | Description |
Store file path into | Stores the file path of the image extracted from the specified cell. |
Using Variables in Conditions
You can use variables for most input fields in this command. For example, the Excel instance can be a variable created by the Launch Excel or Get active worksheet from Excel command. The Worksheet name can come from a text variable, while Row and Column accept numeric or text variables to define cell positions dynamically. The Save image to field also supports variables, allowing you to set the destination folder path at runtime. This flexibility helps make the export process more dynamic and adaptable to different workbooks or file structures.
Notes
The Excel instance must already be open and active.
File names are generated automatically; check the output folder for details.
Ensure the specified row and column exist; invalid references may cause errors.