XlsValidation module

class XlsValidation.XlsValidation

Bases: IDataValidation, IExcelApplication, IOptimizedUpdate, ICloneParent

AddRange

property AlertStyle: AlertStyleType

property AllowType: CellDataType

BeginUpdate()

Clone(parent: SpireObject) → SpireObject

property CompareOperator: ValidationComparisonOperator

ContainsCell(lCellIndex: int) → bool

property DataRange: IXLSRange

property DateTime1: DateTime

property DateTime2: DateTime

EndUpdate()

property ErrorMessage: str

property ErrorTitle: str

property Formula1: str

property Formula2: str

property IgnoreBlank: bool

property InputMessage: str

property InputTitle: str

property IsInputPositionFixed: bool

property IsInputVisible: bool

property IsListInFormula: bool

property IsSuppressDropDownArrow: bool

property Parent: SpireObject

property ParentCollection: XlsDataValidationCollection

property PromptBoxHPosition: int

property PromptBoxVPosition: int

RemoveRange

property ShapesCount: int

property ShowError: bool

property ShowInput: bool

property Values: List[str]

property Worksheet: XlsWorksheet