Class ExcelDataValidationCollection

Namespace

OfficeOpenXml.DataValidation

Assembly

Magicodes.EPPlus.dll

public class ExcelDataValidationCollection : XmlHelper, IEnumerable<IExcelDataValidation>, IEnumerable

Inheritance

object

XmlHelper

ExcelDataValidationCollection

Implements

IEnumerable<IExcelDataValidation>

IEnumerable

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Extension Methods

ExtensionMethods.IsNumeric(object)

Properties

Count

public int Count { get; }

Property Value

int

InternalValidationEnabled

public bool InternalValidationEnabled { get; set; }

Property Value

bool

this[int]

public IExcelDataValidation this[int index] { get; set; }

Parameters

index int

Property Value

IExcelDataValidation

this[string]

public IExcelDataValidation this[string address] { get; }

Parameters

address string

Property Value

IExcelDataValidation

Methods

AddAnyValidation(string)

public IExcelDataValidationAny AddAnyValidation(string address)

Parameters

address string

Returns

IExcelDataValidationAny

AddCustomValidation(string)

public IExcelDataValidationCustom AddCustomValidation(string address)

Parameters

address string

Returns

IExcelDataValidationCustom

AddDateTimeValidation(string)

public IExcelDataValidationDateTime AddDateTimeValidation(string address)

Parameters

address string

Returns

IExcelDataValidationDateTime

AddDecimalValidation(string)

public IExcelDataValidationDecimal AddDecimalValidation(string address)

Parameters

address string

Returns

IExcelDataValidationDecimal

AddIntegerValidation(string)

public IExcelDataValidationInt AddIntegerValidation(string address)

Parameters

address string

Returns

IExcelDataValidationInt

AddListValidation(string)

public IExcelDataValidationList AddListValidation(string address)

Parameters

address string

Returns

IExcelDataValidationList

AddTextLengthValidation(string)

public IExcelDataValidationInt AddTextLengthValidation(string address)

Parameters

address string

Returns

IExcelDataValidationInt

AddTimeValidation(string)

public IExcelDataValidationTime AddTimeValidation(string address)

Parameters

address string

Returns

IExcelDataValidationTime

Clear()

public void Clear()

Find(Predicate<IExcelDataValidation>)

public IExcelDataValidation Find(Predicate<IExcelDataValidation> match)

Parameters

match Predicate<IExcelDataValidation>

Returns

IExcelDataValidation

FindAll(Predicate<IExcelDataValidation>)

public IEnumerable<IExcelDataValidation> FindAll(Predicate<IExcelDataValidation> match)

Parameters

match Predicate<IExcelDataValidation>

Returns

IEnumerable<IExcelDataValidation>

Remove(IExcelDataValidation)

public bool Remove(IExcelDataValidation item)

Parameters

item IExcelDataValidation

Returns

bool

RemoveAll(Predicate<IExcelDataValidation>)

public void RemoveAll(Predicate<IExcelDataValidation> match)

Parameters

match Predicate<IExcelDataValidation>