openpyxl.drawing.spreadsheet绘图模块

class openpyxl.drawing.spreadsheet_drawing.AbsoluteAnchor(pos=None, ext=None, **kw)[源代码]

基类:openpyxl.drawing.spreadsheet_drawing._AnchorBase

clientData

值的类型必须为<class'openpyxl.drawing.spreadsheet_drawing.anchorClientData'>

contentPart

值的类型必须小于class'str'>

cxnSp

值的类型必须小于class“openpyxl.drawing.connector.shape”>

ext

值的类型必须小于class“openpyxl.drawing.xdr.xdrpositivesize2d”>

graphicFrame

值的类型必须小于class“openpyxl.drawing.graphic.graphicframe”>

grpSp

值的类型必须小于class“openpyxl.drawing.graphic.groupshape”>

pic

值的类型必须小于class“openpyxl.drawing.picture.pictureframe”>

pos

值的类型必须小于class“openpyxl.drawing.xdr.xdrpoint2d”>

sp

值的类型必须小于class“openpyxl.drawing.connector.shape”>

tagname = 'absoluteAnchor'
class openpyxl.drawing.spreadsheet_drawing.AnchorClientData(fLocksWithSheet=None, fPrintsWithSheet=None)[源代码]

基类:openpyxl.descriptors.serialisable.Serialisable

fLocksWithSheet

值的类型必须小于class'bool'>

fPrintsWithSheet

值的类型必须小于class'bool'>

class openpyxl.drawing.spreadsheet_drawing.AnchorMarker(col=0, colOff=0, row=0, rowOff=0)[源代码]

基类:openpyxl.descriptors.serialisable.Serialisable

col

值的类型必须小于class“int”>

colOff

值的类型必须小于class“int”>

row

值的类型必须小于class“int”>

rowOff

值的类型必须小于class“int”>

tagname = 'marker'
class openpyxl.drawing.spreadsheet_drawing.OneCellAnchor(_from=None, ext=None, **kw)[源代码]

基类:openpyxl.drawing.spreadsheet_drawing._AnchorBase

clientData

值的类型必须为<class'openpyxl.drawing.spreadsheet_drawing.anchorClientData'>

contentPart

值的类型必须小于class'str'>

cxnSp

值的类型必须小于class“openpyxl.drawing.connector.shape”>

ext

值的类型必须小于class“openpyxl.drawing.xdr.xdrpositivesize2d”>

graphicFrame

值的类型必须小于class“openpyxl.drawing.graphic.graphicframe”>

grpSp

值的类型必须小于class“openpyxl.drawing.graphic.groupshape”>

pic

值的类型必须小于class“openpyxl.drawing.picture.pictureframe”>

sp

值的类型必须小于class“openpyxl.drawing.connector.shape”>

tagname = 'oneCellAnchor'
class openpyxl.drawing.spreadsheet_drawing.SpreadsheetDrawing(twoCellAnchor=(), oneCellAnchor=(), absoluteAnchor=())[源代码]

基类:openpyxl.descriptors.serialisable.Serialisable

PartName = '/xl/drawings/drawing{0}.xml'
absoluteAnchor

只能包含声明类型的对象的序列(列表或元组)

mime_type = 'application/vnd.openxmlformats-officedocument.drawing+xml'
oneCellAnchor

只能包含声明类型的对象的序列(列表或元组)

property path
tagname = 'wsDr'
twoCellAnchor

只能包含声明类型的对象的序列(列表或元组)

class openpyxl.drawing.spreadsheet_drawing.TwoCellAnchor(editAs=None, _from=None, to=None, **kw)[源代码]

基类:openpyxl.drawing.spreadsheet_drawing._AnchorBase

clientData

值的类型必须为<class'openpyxl.drawing.spreadsheet_drawing.anchorClientData'>

contentPart

值的类型必须小于class'str'>

cxnSp

值的类型必须小于class“openpyxl.drawing.connector.shape”>

editAs

值必须是{‘Absolute’,‘onecell’,‘TwoCell’}之一

graphicFrame

值的类型必须小于class“openpyxl.drawing.graphic.graphicframe”>

grpSp

值的类型必须小于class“openpyxl.drawing.graphic.groupshape”>

pic

值的类型必须小于class“openpyxl.drawing.picture.pictureframe”>

sp

值的类型必须小于class“openpyxl.drawing.connector.shape”>

tagname = 'twoCellAnchor'
to

值的类型必须为<class'openpyxl.drawing.spreadsheet_drawing.anchormarker'>