Class ExcelExLstDataValidationCollection
Data validations for the ext lst (x14) section
Implements
System.Collections.Generic.IEnumerable<IExcelDataValidation>
System.Collections.IEnumerable
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: OfficeOpenXml.DataValidation
Assembly: EPPlus.dll
Syntax
public class ExcelExLstDataValidationCollection : XmlHelper, IEnumerable<IExcelDataValidation>, IEnumerableProperties
IsEmpty
Returns true if the list is empty
Declaration
public bool IsEmpty { get; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
Methods
AddValidation<T>(IExcelDataValidationWithFormula<T>)
Adds a validation
Declaration
public IExcelDataValidationWithFormula<T> AddValidation<T>(IExcelDataValidationWithFormula<T> item)
where T : IExcelDataValidationFormulaParameters
| Type | Name | Description |
|---|---|---|
| IExcelDataValidationWithFormula<T> | item |
Returns
| Type | Description |
|---|---|
| IExcelDataValidationWithFormula<T> |
Type Parameters
| Name | Description |
|---|---|
| T |
AddValidation<T>(IExcelDataValidationWithFormula2<T>)
Adds a validation
Declaration
public IExcelDataValidationWithFormula2<T> AddValidation<T>(IExcelDataValidationWithFormula2<T> item)
where T : IExcelDataValidationFormulaParameters
| Type | Name | Description |
|---|---|---|
| IExcelDataValidationWithFormula2<T> | item |
Returns
| Type | Description |
|---|---|
| IExcelDataValidationWithFormula2<T> |
Type Parameters
| Name | Description |
|---|---|
| T |
GetEnumerator()
Returns an enumerator that iterates through the collection.
Declaration
public IEnumerator<IExcelDataValidation> GetEnumerator()Returns
| Type | Description |
|---|---|
| System.Collections.Generic.IEnumerator<IExcelDataValidation> | An enumerator that can be used to iterate through the collection. |
Remove(IExcelDataValidation)
Removes an ExcelDataValidation from the collection.
Declaration
public bool Remove(IExcelDataValidation item)Parameters
| Type | Name | Description |
|---|---|---|
| IExcelDataValidation | item | The item to remove |
Returns
| Type | Description |
|---|---|
| System.Boolean | True if remove succeeds, otherwise false |
Exceptions
| Type | Condition |
|---|---|
| System.ArgumentNullException | if |
Explicit Interface Implementations
IEnumerable.GetEnumerator()
Returns an enumerator that iterates through the collection.
Declaration
IEnumerator IEnumerable.GetEnumerator()Returns
| Type | Description |
|---|---|
| System.Collections.IEnumerator | An enumerator that can be used to iterate through the collection. |
Implements
System.Collections.Generic.IEnumerable<T>
System.Collections.IEnumerable