Excel.ListDataValidation interface

Represents the List data validation criteria.

[ API set: ExcelApi 1.8 ]

Properties

inCellDropDown

Displays the list in cell drop down or not, it defaults to true.

[ API set: ExcelApi 1.8 ]

source

Source of the list for data validation When setting the value, it can be passed in as a Excel Range object, or a string that contains comma separated number, boolean or date.

[ API set: ExcelApi 1.8 ]

Property Details

inCellDropDown

Displays the list in cell drop down or not, it defaults to true.

[ API set: ExcelApi 1.8 ]

inCellDropDown: boolean;

Property Value

boolean

source

Source of the list for data validation When setting the value, it can be passed in as a Excel Range object, or a string that contains comma separated number, boolean or date.

[ API set: ExcelApi 1.8 ]

source: string | Range;

Property Value

string | Range