openpyxl.worksheet.controls module¶
-
class
openpyxl.worksheet.controls.
Control
(controlPr=None, shapeId=None, name=None)[source]¶ Bases:
openpyxl.descriptors.serialisable.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:
openpyxl.descriptors.serialisable.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:
openpyxl.descriptors.serialisable.Serialisable
-
control
¶ A sequence (list or tuple) that may only contain objects of the declared type
-
tagname
= 'controls'¶
-