Message-ID: <1772254122.10539.1711727942445.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_10538_1322685517.1711727942445" ------=_Part_10538_1322685517.1711727942445 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, String)

Workbook.CreateDataValidation(DataValidation.ValidationType, DataVa= lidation.ComparisonType, String, 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 minimumValue, System.String maximumVa=
lue)
=20
=20
vb.net
=20
Public Function CreateDataValidation(ByVal allowedType As ValidationType, B=
yVal comparison As ComparisonType, ByVal minimumValue As String, ByVal maxi=
mumValue As String) As DataValidation
=20
=20

Parameters

=20
allowedType
The d= ata type allowed in the cell.=20
comparison
The com= parison used to validate the cell's value.=20
minimumValue
A f= ormula representing the cell's maximum value.=20
maximumValue
A f= ormula representing the cell's minimum value.=20

Returns

A=20 DataValidation= object.=20

Examples

=20
C#
=20

          DataValidation dataValidation =3D
               wb.createDataValidation(
               DataValidation.ValidationType.WholeNumber,
               DataValidation.ComparisonType.Between, "=3D1", &qu=
ot;=3D100");
        
=20
=20
vb.net
=20

          Dim dataValidation As DataValidation =3D _
               wb.createDataValidation( _
               DataValidation.ValidationType.WholeNumber, _
               DataValidation.ComparisonType.Between, "=3D1", &qu=
ot;=3D100")
        
=20
------=_Part_10538_1322685517.1711727942445--