Help Centre › Building Processes
This article describes the RPA Excel functionality to insert an image into a sheet.
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL Add image function inserts an image into a sheet at a specified cell position. The image is anchored to the top-left corner of the cell.
Setting it up
To use the EXCEL Add image function, follow these instructions:
{{popups:rpas/add:action=excel-add-image}}
Once on a process map:
- Navigate to the process where you would like to add the EXCEL Add image function
- Click on the green button's drop-down (right side of the green button labelled "Process")
- On the menu that appears, click on the "+ Activity" item
- From here you can select the EXCEL Add image option
- Click "Add" once you are done
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| File path | Yes | Text | – | Full path to the Excel file. |
| Sheet | Yes | Text | – | Name of the sheet. |
| Image path | Yes | Text | – | Path to the image file. |
| Anchor cell | No | Text | Current cell | Cell to anchor the image to (e.g. A1). |
| Image name | No | Text | – | Name for the image object. |
| Width | No | Number | – | Image width in pixels. |
| Height | No | Number | – | Image height in pixels. |
Output variables
This action does not produce any output variables.
Errors
| Error | Description |
|---|---|
| File not open | The Excel file must be open. |
| Sheet not found | The specified sheet does not exist. |
| Image not found | The image file does not exist at the specified path. |
Tips
- Supported image formats include PNG, JPG, BMP, and GIF.
- If width and height are omitted, the image is inserted at its original size.
- Give the image a name so you can remove it later with the Remove image function.