Table of Contents

Interface IXLDataValidation

Namespace
SlapKit.Excel.Excel
Assembly
SlapKit.Excel.dll
public interface IXLDataValidation
Extension Methods

Properties

AllowedValues 

XLAllowedValues AllowedValues { get; set; }

Property Value

XLAllowedValues

Date 

XLDateCriteria Date { get; }

Property Value

XLDateCriteria

Decimal 

XLDecimalCriteria Decimal { get; }

Property Value

XLDecimalCriteria

ErrorMessage 

string ErrorMessage { get; set; }

Property Value

string

ErrorStyle 

XLErrorStyle ErrorStyle { get; set; }

Property Value

XLErrorStyle

ErrorTitle 

string ErrorTitle { get; set; }

Property Value

string

IgnoreBlanks 

bool IgnoreBlanks { get; set; }

Property Value

bool

InCellDropdown 

bool InCellDropdown { get; set; }

Property Value

bool

InputMessage 

string InputMessage { get; set; }

Property Value

string

InputTitle 

string InputTitle { get; set; }

Property Value

string

MaxValue 

string MaxValue { get; set; }

Property Value

string

MinValue 

string MinValue { get; set; }

Property Value

string

Operator 

XLOperator Operator { get; set; }

Property Value

XLOperator

Ranges

A collection of ranges the data validation rule applies too.

IEnumerable<IXLRange> Ranges { get; }

Property Value

IEnumerable<IXLRange>

ShowErrorMessage 

bool ShowErrorMessage { get; set; }

Property Value

bool

ShowInputMessage 

bool ShowInputMessage { get; set; }

Property Value

bool

TextLength 

XLTextLengthCriteria TextLength { get; }

Property Value

XLTextLengthCriteria

Time 

XLTimeCriteria Time { get; }

Property Value

XLTimeCriteria

Value 

string Value { get; set; }

Property Value

string

WholeNumber 

XLWholeNumberCriteria WholeNumber { get; }

Property Value

XLWholeNumberCriteria

Methods

AddRange(IXLRange)

Add a range to the collection of ranges this rule applies to. If the specified range does not belong to the worksheet of the data validation rule it is transferred to the target worksheet.

void AddRange(IXLRange range)

Parameters

range IXLRange

A range to add.

AddRanges(IEnumerable<IXLRange>)

Add a collection of ranges to the collection of ranges this rule applies to. Ranges that do not belong to the worksheet of the data validation rule are transferred to the target worksheet.

void AddRanges(IEnumerable<IXLRange> ranges)

Parameters

ranges IEnumerable<IXLRange>

Ranges to add.

Clear() 

void Clear()

ClearRanges()

Detach data validation rule of all ranges it applies to.

void ClearRanges()

Custom(string) 

void Custom(string customValidation)

Parameters

customValidation string

IsDirty() 

bool IsDirty()

Returns

bool

List(IXLRange) 

void List(IXLRange range)

Parameters

range IXLRange

List(IXLRange, bool) 

void List(IXLRange range, bool inCellDropdown)

Parameters

range IXLRange
inCellDropdown bool

List(string) 

void List(string list)

Parameters

list string

List(string, bool) 

void List(string list, bool inCellDropdown)

Parameters

list string
inCellDropdown bool

RemoveRange(IXLRange)

Remove the specified range from the collection of range this rule applies to.

bool RemoveRange(IXLRange range)

Parameters

range IXLRange

A range to remove.

Returns

bool