Help Centre › Building Processes
This article describes the RPA Excel functionality to list all named ranges.
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL List named ranges function lists all named ranges in the workbook. Returns a list of objects, each containing the range name, the cell address it refers to, and the sheet name.
Setting it up
To use the EXCEL List named ranges function, follow these instructions:
{{popups:rpas/add:action=excel-list-named-ranges}}
Once on a process map:
- Navigate to the process where you would like to add the EXCEL List named ranges 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 List named ranges option
- Click "Add" once you are done
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| File path | Yes | Text | – | Full path to the Excel file. |
| Variable | Yes | Text | – | Variable name to store the list of named ranges in. |
Output variables
| Variable | Type | Description |
|---|---|---|
| {variable} | List | A list of objects, each with name, address, and sheet properties. |
Errors
| Error | Description |
|---|---|
| File not open | The Excel file must be open. |
Tips
- Use in a loop to iterate over all named ranges in the workbook.
- Combine with Get named range value to read the contents of each range.