Excel.DataValidationRule interface

Package:

excel

A data validation rule contains different types of data validation. You can only use one of them at a time according the Excel.DataValidationType.

Remarks

[Api set: ExcelApi 1.8]

Properties

custom	Custom data validation criteria.
date	Date data validation criteria.
decimal	Decimal data validation criteria.
list	List data validation criteria.
textLength	Text length data validation criteria.
time	Time data validation criteria.
wholeNumber	Whole number data validation criteria.

Property Details

custom

Custom data validation criteria.

custom?: Excel.CustomDataValidation;

Property Value

Excel.CustomDataValidation

Remarks

[Api set: ExcelApi 1.8]

date

Date data validation criteria.

date?: Excel.DateTimeDataValidation;

Property Value

Excel.DateTimeDataValidation

Remarks

[Api set: ExcelApi 1.8]

decimal

Decimal data validation criteria.

decimal?: Excel.BasicDataValidation;

Property Value

Excel.BasicDataValidation

Remarks

[Api set: ExcelApi 1.8]

list

List data validation criteria.

list?: Excel.ListDataValidation;

Property Value

Excel.ListDataValidation

Remarks

[Api set: ExcelApi 1.8]

textLength

Text length data validation criteria.

textLength?: Excel.BasicDataValidation;

Property Value

Excel.BasicDataValidation

Remarks

[Api set: ExcelApi 1.8]

time

Time data validation criteria.

time?: Excel.DateTimeDataValidation;

Property Value

Excel.DateTimeDataValidation

Remarks

[Api set: ExcelApi 1.8]

wholeNumber

Whole number data validation criteria.

wholeNumber?: Excel.BasicDataValidation;

Property Value

Excel.BasicDataValidation

Remarks

[Api set: ExcelApi 1.8]