Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / DataValidationCollection Class / GetDataValidations Method / GetDataValidations(String,String) Method
The first Address in the range.
The last Address in the range.
Example


In This Topic
    GetDataValidations(String,String) Method
    In This Topic
    Retrieves all the DataValidations in a range, identified by Addresses.
    Syntax
    'Declaration
     
    
    Public Overloads Function GetDataValidations( _
       ByVal startCellAddress As String, _
       ByVal endCellAddress As String _
    ) As IEnumerable(Of DataValidation)
    'Usage
     
    
    Dim instance As DataValidationCollection
    Dim startCellAddress As String
    Dim endCellAddress As String
    Dim value As IEnumerable(Of DataValidation)
     
    value = instance.GetDataValidations(startCellAddress, endCellAddress)

    Parameters

    startCellAddress
    The first Address in the range.
    endCellAddress
    The last Address in the range.
    Example
    List<DataValidation> dvList = doc.Worksheets[ 0 ].DataValidations.GetDataValidations( "A1", "B2");
    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