Xceed Logo
Shop
Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / DataValidationCollection Class
Example


In This Topic
    DataValidationCollection Class
    In This Topic
    Represents the collection of DataValidations found in the Worksheet.
    Object Model
    DataValidationCollection ClassDataValidation Class
    Syntax
    'Declaration
 

    <DefaultMemberAttribute("Item")>
Public Class DataValidationCollection 
   Inherits WorksheetElement
    'Usage
 

    Dim instance As DataValidationCollection
    [DefaultMember("Item")]
public class DataValidationCollection : WorksheetElement
    Example
    doc.Worksheet[0].DataValidations.GetValidationResults();
    Inheritance Hierarchy

    System.Object
       Xceed.Workbooks.NET.WorkbookElement
          Xceed.Workbooks.NET.WorksheetElement
             Xceed.Workbooks.NET.DataValidationCollection

    Public Properties
     NameDescription
    Public PropertyItemGets the DataValidation corresponding to a specific index.  
    Top
    Public Methods
     NameDescription
    Public MethodAddAdds a DataValidation to the Worksheet's DataValidationCollection.  
    Public MethodClearEmpties the DataValidationCollection by removing all DataValidations in the Worksheet.  
    Public MethodCount  
    Public MethodGetDataValidationsOverloaded. Retrieves all DataValidations in a specific range.  
    Public MethodGetEnumerator  
    Public MethodGetValidationResultsGets all Cells that failed the DataValidation process in the current Worksheet.  
    Public MethodRemoveRemoves a specific DataValidation from the DataValidationCollection.  
    Public MethodRemoveValidationsOnRangeRemoves all DataValidations found in a particular range.  
    Top
    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

    Reference

    DataValidationCollection Members
    Xceed.Workbooks.NET Namespace

    Send Feedback