Help Centre › Building Processes
This article describes the RPA Excel functionality to get a cell’s validation.
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL Get a cell’s validation function allows you to get a cell’s validation.
Setting it up
To use the EXCEL Get a cell’s validation function, follow these instructions:
{{popups:rpas/add:action=excel-validation-get}}
Once on a process map:
- Navigate to the process where you would like to add the EXCEL Get a cell’s validation 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 a cell’s validation option
- Click "Add" once you are done
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| Cell | Yes | Text | - | The cell to get validation from |
| Variable | Yes | Text | - | Variable to store the validation rules |
Output variables
| Variable | Type | Description |
|---|---|---|
| Variable | Text | The data validation rules for the cell |
Errors
| Error | Description |
|---|---|
| File not open | The Excel file must be open |
| Invalid cell | The cell reference is not valid |
Tips
- Returns the data validation list or rules configured for the cell