paper-xlsxAPI referenceworksheet.datavalidation

DataValidation

paper-xlsx 0.2.1 API reference

DataValidation(type=None, formula1=None, formula2=None, showErrorMessage=False, showInputMessage=False, showDropDown=False, allowBlank=False, sqref=(), promptTitle=None, errorStyle=None, error=None, prompt=None, errorTitle=None, imeMode=None, operator=None, allow_blank=None)

Attributes

`allowBlank`

attributeallowBlank

= allowBlank

`allow_blank`

attributeallow_blank

= Alias('allowBlank')

`cells`

attributecells

= Alias('sqref')

`error`

attributeerror

= error

`errorStyle`

attributeerrorStyle

= errorStyle

`errorTitle`

attributeerrorTitle

= errorTitle

`formula1`

attributeformula1

= formula1

`formula2`

attributeformula2

= formula2

`hide_drop_down`

attributehide_drop_down

= Alias('showDropDown')

`idx_base`

attributeidx_base

= 0

`imeMode`

attributeimeMode

= imeMode

`namespace`

attributenamespace

= None

`operator`

attributeoperator

= operator

`prompt`

attributeprompt

= prompt

`promptTitle`

attributepromptTitle

= promptTitle

`ranges`

attributeranges

= Alias('sqref')

`showDropDown`

attributeshowDropDown

= showDropDown

`showErrorMessage`

attributeshowErrorMessage

= showErrorMessage

`showInputMessage`

attributeshowInputMessage

= showInputMessage

`sqref`

attributesqref

= sqref

`tagname`

attributetagname

= 'dataValidation'

`type`

attributetype

= type

`validation_type`

attributevalidation_type

= Alias('type')

Functions

`contains`

func__contains__(cell)

paramcell

`iter`

func__iter__()

`add`

funcadd(cell)

Adds a cell or cell coordinate to this validator

paramcell

`from_tree`

funcfrom_tree(node)

Create object from XML

paramnode

`to_tree`

functo_tree(tagname=None, idx=None, namespace=None)

paramtagname

= None

paramidx

= None

paramnamespace

= None

openpyxl.worksheet.datavalidation

paper-xlsx 0.2.1 API reference

DataValidationList

paper-xlsx 0.2.1 API reference