Xceed Logo
Shop
Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / CellRange Class / DataValidation Property
Example


In This Topic
    DataValidation Property (CellRange)
    In This Topic
    Gets or sets the CellRange's DataValidation.
    Syntax
    'Declaration
 

    Public Property DataValidation As DataValidation
    'Usage
 

    Dim instance As CellRange
Dim value As DataValidation
 
instance.DataValidation = value
 
value = instance.DataValidation
    public DataValidation DataValidation {get; set;}
    Example
    //We can get the DataValidation that is applied on the CellRange "B4-D1". If many DataValidations exist on that range, it returns the first one found. It will actually return a DataValidation even if it only partially applies to that range.
DataValidation actual = doc.Worksheets[ 0 ].Cells[ "B4", "D1" ].DataValidation;
    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

    CellRange Class
    CellRange Members

    Send Feedback