Help Centre › Building Processes
This article describes the RPA Excel functionality to add a hyperlink to a cell.
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL Add hyperlink function adds a clickable hyperlink URL to a cell. The URL is stored as a clickable link and an optional display text can be shown instead of the raw URL.
Setting it up
To use the EXCEL Add hyperlink function, follow these instructions:
{{popups:rpas/add:action=excel-add-hyperlink}}
Once on a process map:
- Navigate to the process where you would like to add the EXCEL Add hyperlink 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 hyperlink 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. |
| Cell | Yes | Text | – | Cell address (e.g. A1). |
| URL | Yes | Text | – | The URL to link to. |
| Display text | No | Text | URL value | Text shown in the cell instead of the raw URL. |
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. |
| Invalid cell | The cell reference is not valid. |
Tips
- If display text is not provided, the URL itself is shown in the cell.
- Use variables in the URL to create dynamic links, e.g. https://example.com/{id}.