Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / DataValidationCollection Class / GetDataValidations Method / GetDataValidations(Int32,Int32,Int32,Int32) Method
The Id corresponding to the first Row in the range.
The Id corresponding to the first Column in the range.
The Id corresponding to the last Row in the range.
The Id corresponding to the last Column in the range.
Example


In This Topic
    GetDataValidations(Int32,Int32,Int32,Int32) Method
    In This Topic
    Retrieves all the DataValidations in a range, identified by RowsColumns Ids.
    Syntax
    'Declaration
     
    
    Public Overloads Function GetDataValidations( _
       ByVal startRow As Integer, _
       ByVal startCol As Integer, _
       ByVal endRow As Integer, _
       ByVal endCol As Integer _
    ) As IEnumerable(Of DataValidation)
    'Usage
     
    
    Dim instance As DataValidationCollection
    Dim startRow As Integer
    Dim startCol As Integer
    Dim endRow As Integer
    Dim endCol As Integer
    Dim value As IEnumerable(Of DataValidation)
     
    value = instance.GetDataValidations(startRow, startCol, endRow, endCol)

    Parameters

    startRow
    The Id corresponding to the first Row in the range.
    startCol
    The Id corresponding to the first Column in the range.
    endRow
    The Id corresponding to the last Row in the range.
    endCol
    The Id corresponding to the last Column in the range.
    Example
    List<DataValidation> dvList = doc.Worksheets[ 0 ].DataValidations.GetDataValidations( 0, 0, 1, 1);
    Requirements

    Target Platforms: Windows 11, Windows 10, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

    See Also