fastpyxl.worksheet.datavalidation module

class fastpyxl.worksheet.datavalidation.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)

Bases: Serialisable

add(cell)

Adds a cell or cell coordinate to this validator

allowBlank: bool | None

property allow_blank

property cells

error: str | None

errorStyle: str | None

errorTitle: str | None

formula1: str | None

formula2: str | None

property hide_drop_down

imeMode: str | None

operator: str | None

prompt: str | None

promptTitle: str | None

property ranges

showDropDown: bool | None

showErrorMessage: bool | None

showInputMessage: bool | None

sqref: MultiCellRange | None

tagname = 'dataValidation'

type: str | None

property validation_type

xml_order = ('formula1', 'formula2')

class fastpyxl.worksheet.datavalidation.DataValidationList(disablePrompts=None, xWindow=None, yWindow=None, count=None, dataValidation=())

Bases: Serialisable

append(dv)

property count

dataValidation: list[DataValidation]

disablePrompts: bool | None

tagname = 'dataValidations'

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

Need to skip validations that have no cell ranges

xWindow: int | None

yWindow: int | None

fastpyxl.worksheet.datavalidation.collapse_cell_addresses(cells, input_ranges=())

Collapse a collection of cell co-ordinates down into an optimal range or collection of ranges.

E.g. Cells A1, A2, A3, B1, B2 and B3 should have the data-validation object applied, attempt to collapse down to a single range, A1:B3.

Currently only collapsing contiguous vertical ranges (i.e. above example results in A1:A3 B1:B3).

fastpyxl.worksheet.datavalidation.expand_cell_ranges(range_string)

Expand cell ranges to a sequence of addresses. Reverse of collapse_cell_addresses Eg. converts “A1:A2 B1:B2” to (A1, A2, B1, B2)