ExcelWriter Xojo Plugin

ExcelWriterDataValidation Class (console safe)

A class to define data validation to allow restrictions to be placed on the data that the user can enter in the Excel document and to display associated help and warning messages.

Data validation can also be used to restrict input to values in a drop down list.


class ExcelWriterDataValidation


ExcelWriterDataValidationConstructor that takes ExcelWriterDataValidation.ValidationTypeValues enum as parameter.


Criteria (console safe) Sets or gets the Criteria to be used. This can be any value from the ExcelWriterDataValidation.CriteriaValues enum.
IgnoreBlank (console safe) If set to false then blanks are not ignored. (Default value for this one is true)
MaximumDate (console safe) Sets the maximum date
MaximumNumber (console safe) Sets or gets the maximum number
MinimumDate (console safe) Sets the minimum date.
MinimumNumber (console safe) Sets or gets the minimum number
ValueDate (console safe) Sets date to compare with.
ValueFormula (console safe) Sets formula for the validation.
ValueNumber (console safe) Sets or gets the number to compare with.


SetErrorMessage (console safe) Sets error message for the validation that is used when the user inputs something that does not meet the criteria of the validation.
SetInputMessage (console safe) Sets input message for the validation


ValidationTypeValuesA enum to define the type of data validation.
CriteriaValuesA enum to define the criteria of the data validation.

Supported Platforms:

  • MacOS X Carbon
  • MacOS X Cocoa 32 bit
  • MacOS X Cocoa 64 bit
  • Windows 32 bit
  • Windows 64 bit
  • Linux 32 bit
  • Linux 64 bit
  • Linux ARM