EXCEL Add image function

The EXCEL Add image function inserts an image into a sheet at a specified cell position.

Help CentreBuilding 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:

  1. Navigate to the process where you would like to add the EXCEL Add image function
  2. Click on the green button's drop-down (right side of the green button labelled "Process")
  3. On the menu that appears, click on the "+ Activity" item
  4. From here you can select the EXCEL Add image option
  5. Click "Add" once you are done

Input parameters

ParameterRequiredTypeDefaultDescription
File pathYesTextFull path to the Excel file.
SheetYesTextName of the sheet.
Image pathYesTextPath to the image file.
Anchor cellNoTextCurrent cellCell to anchor the image to (e.g. A1).
Image nameNoTextName for the image object.
WidthNoNumberImage width in pixels.
HeightNoNumberImage height in pixels.

Output variables

This action does not produce any output variables.


Errors

ErrorDescription
File not openThe Excel file must be open.
Sheet not foundThe specified sheet does not exist.
Image not foundThe 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.

Related functions

See it working on your own data

Everything documented here ships with the platform – try the document tools free, or go live in 7 days.