[Root] / 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);
    Supported Frameworks

    .NET: net5.0, net5.0-windows, net6.0, net6.0-macos, net6.0-windows, net7.0, net7.0-macos, net7.0-windows, net8.0, net8.0-browser, net8.0-macos, net8.0-windows, net9.0, net9.0-browser, net9.0-macos, net9.0-windows, net10.0, net10.0-browser, net10.0-macos, net10.0-windows.

    .NET Framework: net40, net403, net45, net451, net452, net46, net461, net462, net463, net47, net471, net472, net48, net481.

    See Also