DataValidationCollection Methods

A collection of DataValidation objects.

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.