IDataValidation module

class IDataValidation.IDataValidation

Bases: IExcelApplication, IOptimizedUpdate

abstract property AlertStyle: AlertStyleType

abstract property AllowType: CellDataType

abstract property CompareOperator: ValidationComparisonOperator

abstract property DataRange: IXLSRange

abstract property DateTime1: DateTime

abstract property DateTime2: DateTime

abstract property ErrorMessage: str

abstract property ErrorTitle: str

abstract property Formula1: str

abstract property Formula2: str

abstract property IgnoreBlank: bool

abstract property InputMessage: str

abstract property InputTitle: str

abstract property IsInputPositionFixed: bool

abstract property IsInputVisible: bool

abstract property IsListInFormula: bool

abstract property IsSuppressDropDownArrow: bool

abstract property PromptBoxHPosition: int

abstract property PromptBoxVPosition: int

abstract property ShowError: bool

abstract property ShowInput: bool

abstract property Values: List[str]