ExcelDataValidation Properties

Office Open XML

The ExcelDataValidation type exposes the following members.

Properties

  NameDescription
Address
Address of data validation
AllowBlank
True if blanks should be allowed
AllowsOperator
True if the validation type allows operator to be set.
Error
Error message box text
ErrorStyle
Warning style
ErrorTitle
Title of error message box
Operator
Operator for comparison between the entered value and Formula/Formulas.
Prompt
PromptTitle
ShowErrorMessage
True if error message should be shown
ShowInputMessage
True if input message should be shown
ValidationType
Validation type

See Also