Excel.ListDataValidation interface

表示列表数据验证条件。Represents the List data validation criteria.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

属性

inCellDropDown

是否显示单元格下拉菜单中的列表,默认为 true。Displays the list in cell drop down or not, it defaults to true.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

source

数据验证列表的源。设置值时, 可以将其作为 Excel 区域对象传入, 或包含逗号分隔的数字、布尔值或日期的字符串。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 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

属性详细信息

inCellDropDown

是否显示单元格下拉菜单中的列表,默认为 true。Displays the list in cell drop down or not, it defaults to true.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

inCellDropDown: boolean;

属性值

boolean

source

数据验证列表的源。设置值时, 可以将其作为 Excel 区域对象传入, 或包含逗号分隔的数字、布尔值或日期的字符串。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 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

source: string | Range;

属性值

string | Range