openpyxl.worksheet.ole module

class openpyxl.worksheet.ole.ObjectAnchor(_from=None, to=None, moveWithCells=False, sizeWithCells=False, z_order=None)[source]

Bases: openpyxl.descriptors.serialisable.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: 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’>

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: openpyxl.descriptors.serialisable.Serialisable

autoLoad

Values must be of type <class ‘bool’>

dvAspect

Value must be one of {‘DVASPECT_CONTENT’, ‘DVASPECT_ICON’}

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_ONCALL’, ‘OLEUPDATE_ALWAYS’}

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: openpyxl.descriptors.serialisable.Serialisable

oleObject

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

tagname = 'oleObjects'