ExcelDataValidationCollection Methods

Office Open XML

The ExcelDataValidationCollection type exposes the following members.

Methods

  NameDescription
AddCustomValidation
Adds a ExcelDataValidationCustom to the worksheet.
AddDateTimeValidation
Adds an IExcelDataValidationDateTime to the worksheet.
AddDecimalValidation
Addes an IExcelDataValidationDecimal to the worksheet. The only accepted values are decimal values.
AddIntegerValidation
Adds an IExcelDataValidationInt to the worksheet. Whole means that the only accepted values are integer values.
AddListValidation
Adds an IExcelDataValidationList to the worksheet. The accepted values are defined in a list.
AddTextLengthValidation
Adds an IExcelDataValidationInt regarding text length to the worksheet.
AddTimeValidation
Clear
Removes all validations from the collection.
Equals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Find
Returns the first matching validation.
FindAll
Returns all validations that matches the supplied predicate match.
GetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
GetType
Gets the Type of the current instance.
(Inherited from Object.)
Remove
Removes an ExcelDataValidation from the collection.
RemoveAll
Removes the validations that matches the predicate
ToString
Returns a String that represents the current Object.
(Inherited from Object.)

See Also