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.

[ API set: ExcelApi 1.8 ]

ignoreBlanks

Ignore blanks: no data validation will be performed on blank cells, it defaults to true.

[ API set: ExcelApi 1.8 ]

prompt

Prompt when users select a cell.

[ API set: ExcelApi 1.8 ]

rule

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

[ API set: ExcelApi 1.8 ]

Property Details

errorAlert

Error alert when user enters invalid data.

[ API set: ExcelApi 1.8 ]

errorAlert?: Excel.DataValidationErrorAlert;

Property Value

ignoreBlanks

Ignore blanks: no data validation will be performed on blank cells, it defaults to true.

[ API set: ExcelApi 1.8 ]

ignoreBlanks?: boolean;

Property Value

boolean

prompt

Prompt when users select a cell.

[ API set: ExcelApi 1.8 ]

prompt?: Excel.DataValidationPrompt;

Property Value

rule

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

[ API set: ExcelApi 1.8 ]

rule?: Excel.DataValidationRule;

Property Value