Creates a DataValidation object which can be set on a Range, Area, or Cell.

 public DataValidation CreateDataValidation(ValidationType allowedType, ComparisonType comparison, System.String minimumValue, System.String maximumValue)
Public Function CreateDataValidation(ByVal allowedType As ValidationType, ByVal comparison As ComparisonType, ByVal minimumValue As String, ByVal maximumValue As String) As DataValidation

The data type allowed in the cell.

The comparison used to validate the cell's value.

A formula representing the cell's maximum value.

A formula representing the cell's minimum value.

A DataValidation object.


          DataValidation dataValidation =
               wb.createDataValidation(
               DataValidation.ValidationType.WholeNumber,
               DataValidation.ComparisonType.Between, "=1", "=100");
        

          Dim dataValidation As DataValidation = _
               wb.createDataValidation( _
               DataValidation.ValidationType.WholeNumber, _
               DataValidation.ComparisonType.Between, "=1", "=100")