DataValidationCollection
General
DataValidationCollection és una classe en Aspose.Cells per a Python.
Representa una col·lecció d’objectes DataValidation per a una fitxa de treball.
Propietats
| Name | Type | Access | Description |
|---|---|---|---|
count | `` | Read | Provides the number of validations in the collection |
disable_prompts | `` | Read | Indicates whether validation prompts are disabled |
x_window | `` | Read | Gets or sets the X coordinate of the validation input window |
y_window | `` | Read |
Mètodes
| 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. |