Edit

Share via

Excel.DataValidationType enum

  • Reference
Package:
excel

Represents the data validation type enum.

Remarks

[ API set: ExcelApi 1.8 ]

Fields

custom = "Custom"

The custom data validation type.
date = "Date"

The date data validation type.
decimal = "Decimal"

The decimal data validation type.
inconsistent = "Inconsistent"

Inconsistent means that the range has inconsistent data validation, indicating that there are different rules on different cells.
list = "List"

The list data validation type.
mixedCriteria = "MixedCriteria"

Mixed criteria means that the range has data validation present on some but not all cells.
none = "None"

None means allow any value, indicating that there is no data validation in the range.
textLength = "TextLength"

The text length data validation type.
time = "Time"

The time data validation type.
wholeNumber = "WholeNumber"

The whole number data validation type.