Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin
Description

Excerpt

Creates a DataValidation object which can be set on a Range, Area, or Cell.

Signature
C#
C#
 public DataValidation CreateDataValidation(ValidationType allowedType, System.Object sourceArray)
Signature
vb.net
vb.net
Public Function CreateDataValidation(ByVal allowedType As ValidationType, ByVal sourceArray As Object) As DataValidation
Parameters
Param
allowedType
allowedType

The data type allowed in the cell.

Param
sourceArray
sourceArray

For 'List' allowed type: the array of valid values for the cell.

Returns

A DataValidation object.

Example
Code Block
csharp
csharp
titleC#

          DataValidation dataValidation =
               wb.createDataValidation(
               DataValidation.ValidationType.List,
               listArray);
        
Code Block
vb.net
vb.net
titlevb.net

          Dim dataValidation As DataValidation = _
               wb.createDataValidation( _
               DataValidation.ValidationType.List, _
               listArray)