Page History

{description}
{excerpt}Creates a [DataValidation] object which can be set on a [Range], [Area], or [Cell].{excerpt}
{signature:C#}
 public DataValidation CreateDataValidation(ValidationType allowedType, ComparisonType comparison, System.String value)

{signature}{signature:vb.net

}
Public Function CreateDataValidation(ByVal allowedType As ValidationType, ByVal comparison As ComparisonType, ByVal value As String) As DataValidation

...

The data type allowed in the cell.

...

The comparison used to validate the cell's value.

...

A formula representing the constraint for the data validation.

{signature}
{parameters}
{param:allowedType}The data type allowed in the cell.{param}
{param:comparison}The comparison used to validate the cell's value.{param}
{param:value}A formula representing the constraint for the data validation.{param}
{returns}A [DataValidation|DataValidation] object.{returns}
{example}{code:csharp|title=C#}

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

{code}
{code:vb.net

|title=vb.net

}

          Dim dataValidation As DataValidation = _
               wb.createDataValidation( _
               DataValidation.ValidationType.WholeNumber, _
               DataValidation.ComparisonType.LessThan, "=1")
        {code}

{example}