Help Centre › Building Processes
This article describes the RPA Excel functionality to read a named range value.
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL Get named range value function reads the value(s) of a named range and stores the result in a variable. Returns a single value for a single cell, or a list for a multi-cell range.
Setting it up
To use the EXCEL Get named range value function, follow these instructions:
{{popups:rpas/add:action=excel-get-named-range}}
Once on a process map:
- Navigate to the process where you would like to add the EXCEL Get named range value 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 Get named range value option
- Click "Add" once you are done
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| File path | Yes | Text | – | Full path to the Excel file. |
| Range name | Yes | Text | – | Name of the named range to read. |
| Variable | Yes | Text | – | Variable name to store the value(s) in. |
Output variables
| Variable | Type | Description |
|---|---|---|
| {variable} | Text or List | A single value for a single-cell range, or a list of values for a multi-cell range. |
Errors
| Error | Description |
|---|---|
| File not open | The Excel file must be open. |
| Named range not found | The specified named range does not exist in the workbook. |
Tips
- Use List named ranges to discover available named ranges first.
- For multi-cell ranges, the result is a list that can be used in a loop.