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();
    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