Message-ID: <751462078.7905.1711625473750.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_7904_662420818.1711625473750" ------=_Part_7904_662420818.1711625473750 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Workbook.CreateDataValidation(DataValidation.ValidationType, Str= ing)

Workbook.CreateDataValidation(DataValidation.ValidationType, String= )

Description

=20

Creates a DataValidation ob= ject which can be set on a Range, Area, or Cell<= /a>.

=20
C#
=20
 public DataValidation CreateDataValidation(ValidationType allowedType, Sys=
tem.String formula)
=20
=20
vb.net
=20
Public Function CreateDataValidation(ByVal allowedType As ValidationType, B=
yVal formula As String) As DataValidation
=20
=20

Parameters

=20
allowedType
The data type allowed in the cell.=20
formula
For 'Custom' allowed type: the formula used to val= idate the cell's data. For 'List' allowed type: the formula referencing a r= ange in the worksheet.=20

Returns

A=20
DataValidation object.=20

Examples

=20
C#
=20

          DataValidation dataValidation =3D
               wb.createDataValidation(
               DataValidation.ValidationType.List,
               "C10:C18");
        
=20
=20
vb.net
=20

          Dim dataValidation As DataValidation =3D _
               wb.createDataValidation( _
               DataValidation.ValidationType.List, _
               "C10:C18")
        
=20
------=_Part_7904_662420818.1711625473750--