openpyxl.worksheet.controls module

class openpyxl.worksheet.controls.Control(controlPr=None, shapeId=None, name=None)[source]

Bases: Serialisable

controlPr

Values must be of type <class ‘openpyxl.worksheet.controls.ControlProperty’>

name

Values must be of type <class ‘str’>

shapeId

Values must be of type <class ‘int’>

tagname = 'control'
class openpyxl.worksheet.controls.ControlProperty(anchor=None, locked=True, defaultSize=True, _print=True, disabled=False, recalcAlways=False, uiObject=False, autoFill=True, autoLine=True, autoPict=True, macro=None, altText=None, linkedCell=None, listFillRange=None, cf='pict', id=None)[source]

Bases: Serialisable

altText

Values must be of type <class ‘str’>

anchor

Values must be of type <class ‘openpyxl.worksheet.ole.ObjectAnchor’>

autoFill

Values must be of type <class ‘bool’>

autoLine

Values must be of type <class ‘bool’>

autoPict

Values must be of type <class ‘bool’>

cf

Values must be of type <class ‘str’>

defaultSize

Values must be of type <class ‘bool’>

disabled

Values must be of type <class ‘bool’>

id

Values must be of type <class ‘str’>

linkedCell

Values must be of type <class ‘str’>

listFillRange

Values must be of type <class ‘str’>

locked

Values must be of type <class ‘bool’>

macro

Values must be of type <class ‘str’>

recalcAlways

Values must be of type <class ‘bool’>

tagname = 'controlPr'
uiObject

Values must be of type <class ‘bool’>

class openpyxl.worksheet.controls.Controls(control=())[source]

Bases: Serialisable

control

A sequence (list or tuple) that may only contain objects of the declared type

tagname = 'controls'