EXCEL Get a cell’s validation function

The EXCEL Get a cell’s validation function in RPA.

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

  1. Navigate to the process where you would like to add the EXCEL Get a cell’s validation 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 Get a cell’s validation option
  5. Click "Add" once you are done

Input parameters

ParameterRequiredTypeDefaultDescription
CellYesText-The cell to get validation from
VariableYesText-Variable to store the validation rules

Output variables

VariableTypeDescription
VariableTextThe data validation rules for the cell

Errors

ErrorDescription
File not openThe Excel file must be open
Invalid cellThe cell reference is not valid

Tips

  • Returns the data validation list or rules configured for the cell

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.