openpyxl.drawing.spreadsheet_drawing module
- class openpyxl.drawing.spreadsheet_drawing.AbsoluteAnchor(pos=None, ext=None, **kw)[source]
Bases:
_AnchorBase- clientData
Values must be of type <class ‘openpyxl.drawing.spreadsheet_drawing.AnchorClientData’>
- contentPart
Values must be of type <class ‘str’>
- cxnSp
Values must be of type <class ‘openpyxl.drawing.connector.Shape’>
- ext
Values must be of type <class ‘openpyxl.drawing.xdr.XDRPositiveSize2D’>
- graphicFrame
Values must be of type <class ‘openpyxl.drawing.graphic.GraphicFrame’>
- grpSp
Values must be of type <class ‘openpyxl.drawing.graphic.GroupShape’>
- pic
Values must be of type <class ‘openpyxl.drawing.picture.PictureFrame’>
- pos
Values must be of type <class ‘openpyxl.drawing.xdr.XDRPoint2D’>
- sp
Values must be of type <class ‘openpyxl.drawing.connector.Shape’>
- tagname = 'absoluteAnchor'
- class openpyxl.drawing.spreadsheet_drawing.AnchorClientData(fLocksWithSheet=None, fPrintsWithSheet=None)[source]
Bases:
Serialisable- fLocksWithSheet
Values must be of type <class ‘bool’>
- fPrintsWithSheet
Values must be of type <class ‘bool’>
- class openpyxl.drawing.spreadsheet_drawing.AnchorMarker(col=0, colOff=0, row=0, rowOff=0)[source]
Bases:
Serialisable- col
Values must be of type <class ‘int’>
- colOff
Values must be of type <class ‘int’>
- row
Values must be of type <class ‘int’>
- rowOff
Values must be of type <class ‘int’>
- tagname = 'marker'
- class openpyxl.drawing.spreadsheet_drawing.OneCellAnchor(_from=None, ext=None, **kw)[source]
Bases:
_AnchorBase- clientData
Values must be of type <class ‘openpyxl.drawing.spreadsheet_drawing.AnchorClientData’>
- contentPart
Values must be of type <class ‘str’>
- cxnSp
Values must be of type <class ‘openpyxl.drawing.connector.Shape’>
- ext
Values must be of type <class ‘openpyxl.drawing.xdr.XDRPositiveSize2D’>
- graphicFrame
Values must be of type <class ‘openpyxl.drawing.graphic.GraphicFrame’>
- grpSp
Values must be of type <class ‘openpyxl.drawing.graphic.GroupShape’>
- pic
Values must be of type <class ‘openpyxl.drawing.picture.PictureFrame’>
- sp
Values must be of type <class ‘openpyxl.drawing.connector.Shape’>
- tagname = 'oneCellAnchor'
- class openpyxl.drawing.spreadsheet_drawing.SpreadsheetDrawing(twoCellAnchor=(), oneCellAnchor=(), absoluteAnchor=())[source]
Bases:
Serialisable- PartName = '/xl/drawings/drawing{0}.xml'
- absoluteAnchor
A sequence (list or tuple) that may only contain objects of the declared type
- mime_type = 'application/vnd.openxmlformats-officedocument.drawing+xml'
- oneCellAnchor
A sequence (list or tuple) that may only contain objects of the declared type
- property path
- tagname = 'wsDr'
- twoCellAnchor
A sequence (list or tuple) that may only contain objects of the declared type
- class openpyxl.drawing.spreadsheet_drawing.TwoCellAnchor(editAs=None, _from=None, to=None, **kw)[source]
Bases:
_AnchorBase- clientData
Values must be of type <class ‘openpyxl.drawing.spreadsheet_drawing.AnchorClientData’>
- contentPart
Values must be of type <class ‘str’>
- cxnSp
Values must be of type <class ‘openpyxl.drawing.connector.Shape’>
- editAs
Value must be one of {‘oneCell’, ‘twoCell’, ‘absolute’}
- graphicFrame
Values must be of type <class ‘openpyxl.drawing.graphic.GraphicFrame’>
- grpSp
Values must be of type <class ‘openpyxl.drawing.graphic.GroupShape’>
- pic
Values must be of type <class ‘openpyxl.drawing.picture.PictureFrame’>
- sp
Values must be of type <class ‘openpyxl.drawing.connector.Shape’>
- tagname = 'twoCellAnchor'
- to
Values must be of type <class ‘openpyxl.drawing.spreadsheet_drawing.AnchorMarker’>