Add

Adds data validation to the specified range.

Syntax

expression.Add(Type, AlertStyle, Operator, Formula1, Formula2);

expression - A variable that represents a ApiValidation class.

Parameters

Name	Required/Optional	Data type	Default	Description
Type	Required	ValidationType		The validation type.
AlertStyle	Optional	ValidationAlertStyle		The validation alert style.
Operator	Optional	ValidationOperator		The data validation operator.
Formula1	Optional	string | number | ApiRange		The first formula in the data validation.
Formula2	Optional	string | number | ApiRange		The second formula in the data validation.

Returns

ApiValidation | null

Example

This example adds a data validation rule to a range of cells.

• Code
• Result

// How to apply data validation to a range of cells.

// Get a range from the worksheet and add data validation to it.

let worksheet = Api.GetActiveSheet();
worksheet.GetRange("A1").SetValue("Data Validation for decimal to be more than 10");
const range = worksheet.GetRange("A2:A3");
range.SetValue("10");
const validation = worksheet.GetRange("A2").GetValidation();
validation.Add("xlValidateDecimal", "xlValidAlertWarning", "xlGreater", "12");
worksheet.GetRange("A4").SetValue("Data Validation is now applied for A2 only");