Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / CellRange Class / GetValidationResults Method
Example


In This Topic
    GetValidationResults Method (CellRange)
    In This Topic
    Gets a list of Cells that have failed the DataValidation process.
    Syntax
    'Declaration
     
    
    Public Function GetValidationResults() As List(Of Cell)
    'Usage
     
    
    Dim instance As CellRange
    Dim value As List(Of Cell)
     
    value = instance.GetValidationResults()
    public List<Cell> GetValidationResults()
    Remarks
    Returns null if all Values are valid.
    Example
    Gets the result of the DataValidation process for a particular CellRange.
    doc.Worksheet[0].Cells["A1", "F5"].GetValidationResult();
    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