openpyxl.worksheet.ole module
- class openpyxl.worksheet.ole.ObjectAnchor(_from=None, to=None, moveWithCells=False, sizeWithCells=False, z_order=None)[source]
Bases:
Serialisable- moveWithCells
Values must be of type <class ‘bool’>
- sizeWithCells
Values must be of type <class ‘bool’>
- tagname = 'anchor'
- to
Values must be of type <class ‘openpyxl.drawing.spreadsheet_drawing.AnchorMarker’>
- z_order
Values must be of type <class ‘int’>
- class openpyxl.worksheet.ole.ObjectPr(anchor=None, locked=True, defaultSize=True, _print=True, disabled=False, uiObject=False, autoFill=True, autoLine=True, autoPict=True, macro=None, altText=None, dde=False)[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’>
- dde
Values must be of type <class ‘bool’>
- defaultSize
Values must be of type <class ‘bool’>
- disabled
Values must be of type <class ‘bool’>
- locked
Values must be of type <class ‘bool’>
- macro
Values must be of type <class ‘str’>
- tagname = 'objectPr'
- uiObject
Values must be of type <class ‘bool’>
- class openpyxl.worksheet.ole.OleObject(objectPr=None, progId=None, dvAspect='DVASPECT_CONTENT', link=None, oleUpdate=None, autoLoad=False, shapeId=None)[source]
Bases:
Serialisable- autoLoad
Values must be of type <class ‘bool’>
- dvAspect
Value must be one of {‘DVASPECT_ICON’, ‘DVASPECT_CONTENT’}
- link
Values must be of type <class ‘str’>
- objectPr
Values must be of type <class ‘openpyxl.worksheet.ole.ObjectPr’>
- oleUpdate
Value must be one of {‘OLEUPDATE_ALWAYS’, ‘OLEUPDATE_ONCALL’}
- progId
Values must be of type <class ‘str’>
- shapeId
Values must be of type <class ‘int’>
- tagname = 'oleObject'
- class openpyxl.worksheet.ole.OleObjects(oleObject=())[source]
Bases:
Serialisable- oleObject
A sequence (list or tuple) that may only contain objects of the declared type
- tagname = 'oleObjects'