DataValidationCollection
Overview
DataValidationCollection is a class in Aspose.Cells FOSS for Python.
Represents a collection of DataValidation objects for a worksheet.
Properties
| Name | Type | Access | Description |
|---|---|---|---|
count | `` | Read | Gets the number of validations in the collection. |
disable_prompts | `` | Read | Gets or sets whether all input prompts are disabled. |
x_window | `` | Read | Gets or sets the X coordinate of the dropdown window. |
y_window | `` | Read | Gets or sets the Y coordinate of the dropdown window. |
Methods
| Signature | Description |
|---|---|
__init__() | Initializes a new DataValidationCollection. |
add(sqref, validation_type, operator, formula1, formula2) | Adds a new data validation to the collection. |
add_validation(validation) | Adds an existing DataValidation object to the collection. |
remove(validation) | Removes a validation from the collection. |
remove_at(index) | Removes a validation at the specified index. |
remove_by_range(sqref) | Removes validations that match the specified range. |
clear() | Removes all validations from the collection. |
get_validation(cell_ref) | Gets the validation that applies to a specific cell. |