Excel.Interfaces.DataValidationUpdateData interface

一个用于更新 DataValidation 对象上的数据的接口, 可用于 "DataValidation (An interface for updating data on the DataValidation object, for use in "dataValidation.set({ ... })".

属性

errorAlert

用户输入无效数据时,出现错误警报。Error alert when user enters invalid data.

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

ignoreBlanks

忽略空白:不会对空白单元格执行数据严重,默认为 true。Ignore blanks: no data validation will be performed on blank cells, it defaults to true.

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

prompt

当用户选择单元格时提示。Prompt when users select a cell.

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

rule

包含不同类型的数据验证条件的数据有效性规则。Data validation rule that contains different type of data validation criteria.

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

属性详细信息

errorAlert

用户输入无效数据时,出现错误警报。Error alert when user enters invalid data.

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

errorAlert?: Excel.DataValidationErrorAlert;

属性值

ignoreBlanks

忽略空白:不会对空白单元格执行数据严重,默认为 true。Ignore blanks: no data validation will be performed on blank cells, it defaults to true.

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

ignoreBlanks?: boolean;

属性值

boolean

prompt

当用户选择单元格时提示。Prompt when users select a cell.

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

prompt?: Excel.DataValidationPrompt;

属性值

rule

包含不同类型的数据验证条件的数据有效性规则。Data validation rule that contains different type of data validation criteria.

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

rule?: Excel.DataValidationRule;

属性值