Edit

Share via

Excel.ListDataValidation interface

  • Reference
Package:
excel

Represents the List data validation criteria.

Remarks

[ API set: ExcelApi 1.8 ]

Properties

inCellDropDown

Specifies whether to display the list in a cell drop-down. The default is true.
source

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

Property Details

inCellDropDown

Specifies whether to display the list in a cell drop-down. The default is true.

inCellDropDown: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

source

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

source: string | Range;

Property Value

string | Excel.Range

Remarks

[ API set: ExcelApi 1.8 ]