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'