Excel.Interfaces.DataValidationUpdateData interface

An interface for updating data on the DataValidation object, for use in dataValidation.set({ ... }).

Properties

errorAlert	Error alert when user enters invalid data.
ignoreBlanks	Specifies if data validation will be performed on blank cells. Default is `true`.
prompt	Prompt when users select a cell.
rule	Data validation rule that contains different type of data validation criteria.

Error alert when user enters invalid data.

errorAlert?: Excel.DataValidationErrorAlert;

Specifies if data validation will be performed on blank cells. Default is true.

ignoreBlanks?: boolean;

boolean

Prompt when users select a cell.

prompt?: Excel.DataValidationPrompt;

Data validation rule that contains different type of data validation criteria.

rule?: Excel.DataValidationRule;