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

Workbook.CreateDataValidation(DataValidation.ValidationType, Object= )

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, Sys=
tem.Object sourceArray)
=20
=20
vb.net
=20
Public Function CreateDataValidation(ByVal allowedType As ValidationType, B=
yVal sourceArray As Object) As DataValidation
=20
=20

Parameters

=20
allowedType
The data type allowed in the cell.=20
sourceArray
For 'List' allowed type: the array of vali= d values for the cell.=20

Returns

A=20 DataValidation= object.=20

Examples

=20
C#
=20

          DataValidation dataValidation =3D
               wb.createDataValidation(
               DataValidation.ValidationType.List,
               listArray);
        
=20
=20
vb.net
=20

          Dim dataValidation As DataValidation =3D _
               wb.createDataValidation( _
               DataValidation.ValidationType.List, _
               listArray)
        
=20
------=_Part_10350_341403733.1711722315138--