Message-ID: <502599568.8739.1711658406089.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_8738_1550685080.1711658406089" ------=_Part_8738_1550685080.1711658406089 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Workbook.CreateDataValidation(DataValidation.ValidationType, Dat= aValidation.ComparisonType, String)

Workbook.CreateDataValidation(DataValidation.ValidationType, DataVa= lidation.ComparisonType, String)

Description

=20

Creates a DataValidation obj= ect which can be set on a Range, Area, or Cell.=

=20
C#
=20
 public DataValidation CreateDataValidation(ValidationType allowedType, Com=
parisonType comparison, System.String value)
=20
=20
vb.net
=20
Public Function CreateDataValidation(ByVal allowedType As ValidationType, B=
yVal comparison As ComparisonType, ByVal value As String) As DataValidation
=20
=20

Parameters

=20
allowedType
The data typ= e allowed in the cell.=20
comparison
The comparison= used to validate the cell's value.=20
value
A formula representing t= he constraint for the data validation.=20

Returns

A=20 DataValidation= object.=20

Examples

=20
C#
=20

          DataValidation dataValidation =3D
               wb.createDataValidation(
               DataValidation.ValidationType.WholeNumber,
               DataValidation.ComparisonType.LessThan, "=3D1");
        
=20
=20
vb.net
=20

          Dim dataValidation As DataValidation =3D _
               wb.createDataValidation( _
               DataValidation.ValidationType.WholeNumber, _
               DataValidation.ComparisonType.LessThan, "=3D1")
        
=20
------=_Part_8738_1550685080.1711658406089--