Skip to main content
Row

DataValidationCollection Members

A collection of DataValidation objects.

Properties

Name Description
Count Gets the number of elements contained in the ICollection. Inherited from ICollection.
IsSynchronized Gets a value indicating whether access to the ICollection is synchronized (thread safe). Inherited from ICollection.
SyncRoot Gets an object that can be used to synchronize access to the ICollection. Inherited from ICollection.

Methods

Name Description
Add(CellRange, DataValidationType, DataValidationOperator, ValueObject, ValueObject) Creates a new data validation entry and adds it to the document’s collection.
Add(CellRange, DataValidationType, DataValidationOperator, ValueObject) Creates a new data validation entry and adds it to the document’s collection.
Add(CellRange, DataValidationType, ValueObject) Creates a new data validation entry and adds it to the document’s collection.
Clear() Removes all entries from the collection.
Clear(CellRange) Removes data validation criteria from the specified cell range.
Contains(DataValidation) Indicates whether the collection contains the specified item.
CopyTo(Array, Int32) Copies the elements of the ICollection to an Array, starting at a particular Array index. Inherited from ICollection.
GetDataValidation(Cell) Obtains a data validation entry for the specified cell.
GetDataValidations(CellRange) Obtains data validation entries for cells in the specified range.
GetDataValidations(DataValidationType, DataValidationOperator, ValueObject, ValueObject) Obtains data validation entries with the specified properties.
GetEnumerator() Returns an enumerator that iterates through the collection. Inherited from IEnumerable<T>.
GetInvalidCells() Returns cells that do not meet the data validation criteria.
IndexOf(DataValidation) Returns the zero-based index of the specified element in the collection.
Remove(DataValidation) Removes the specified item from the collection.
RemoveAt(Int32) Removes the data validation item at the specified index from the collection.
Validate(Cell, CellValue) Validates the specified value before assigning it to the specified cell.
Validate(Cell) Validates the specified cell value.
See Also