openpyxl.drawing.spreadsheet_drawing module¶
-
class
openpyxl.drawing.spreadsheet_drawing.
AbsoluteAnchor
(pos=None, ext=None, **kw)[source]¶ Bases:
openpyxl.drawing.spreadsheet_drawing._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:
openpyxl.descriptors.serialisable.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:
openpyxl.descriptors.serialisable.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:
openpyxl.drawing.spreadsheet_drawing._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:
openpyxl.descriptors.serialisable.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
-
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:
openpyxl.drawing.spreadsheet_drawing._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 {‘twoCell’, ‘absolute’, ‘oneCell’}
-
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’>
-