openpyxl.drawing.shapes module

class openpyxl.drawing.shapes.AdjPoint2D(x=None, y=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

x

Values must be of type <class ‘int’>

y

Values must be of type <class ‘int’>

class openpyxl.drawing.shapes.AdjustHandleList

Bases: openpyxl.descriptors.serialisable.Serialisable

class openpyxl.drawing.shapes.Backdrop(anchor=None, norm=None, up=None, extLst=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

anchor

Values must be of type <class ‘openpyxl.drawing.shapes.Point3D’>

extLst

Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>

norm

Values must be of type <class ‘openpyxl.drawing.shapes.Vector3D’>

up

Values must be of type <class ‘openpyxl.drawing.shapes.Vector3D’>

class openpyxl.drawing.shapes.Bevel(w=None, h=None, prst=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

h

Values must be of type Values must be of type <class ‘int’>

prst

Values must be of type <openpyxl.descriptors.base.Set object at 0x7f9578aaa5f8>

w

Values must be of type Values must be of type <class ‘int’>

class openpyxl.drawing.shapes.Camera(prst=None, fov=None, zoom=None, rot=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

fov

Values must be of type <class ‘openpyxl.descriptors.base.Integer’>

prst

Values must be of type <openpyxl.descriptors.base.Set object at 0x7f9578a30668>

rot

Values must be of type <class ‘openpyxl.drawing.shapes.SphereCoords’>

zoom

Values must be of type <class ‘openpyxl.descriptors.excel.Percentage’>

class openpyxl.drawing.shapes.ConnectionSite(ang=None, pos=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

ang

Values must be of type <class ‘float’>

pos

Values must be of type <class ‘openpyxl.drawing.shapes.AdjPoint2D’>

class openpyxl.drawing.shapes.ConnectionSiteList(cxn=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

cxn

Values must be of type <class ‘openpyxl.drawing.shapes.ConnectionSite’>

class openpyxl.drawing.shapes.CustomGeometry2D(avLst=None, gdLst=None, ahLst=None, cxnLst=None, rect=None, pathLst=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

ahLst

Values must be of type <class ‘openpyxl.drawing.shapes.AdjustHandleList’>

avLst

Values must be of type <class ‘openpyxl.drawing.shapes.GeomGuideList’>

cxnLst

Values must be of type <class ‘openpyxl.drawing.shapes.ConnectionSiteList’>

gdLst

Values must be of type <class ‘openpyxl.drawing.shapes.GeomGuideList’>

pathLst

Values must be of type <class ‘openpyxl.drawing.shapes.Path2DList’>

rect

Values must be of type <class ‘openpyxl.drawing.shapes.GeomRect’>

class openpyxl.drawing.shapes.FontReference(idx=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

idx

Value must be one of {‘major’, ‘minor’}

class openpyxl.drawing.shapes.GeomGuide(name=None, fmla=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

fmla

Values must be of type <class ‘str’>

name

Values must be of type <class ‘str’>

class openpyxl.drawing.shapes.GeomGuideList(gd=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

gd

Values must be of type <class ‘openpyxl.drawing.shapes.GeomGuide’>

class openpyxl.drawing.shapes.GeomRect(l=None, t=None, r=None, b=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

b

Values must be of type <class ‘int’>

l

Values must be of type <class ‘int’>

r

Values must be of type <class ‘int’>

t

Values must be of type <class ‘int’>

class openpyxl.drawing.shapes.LightRig(rig=None, dir=None, rot=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

dir

Values must be of type <openpyxl.descriptors.base.Set object at 0x7f95789b3080>

rig

Values must be of type <openpyxl.descriptors.base.Set object at 0x7f9578a30b70>

rot

Values must be of type <class ‘openpyxl.drawing.shapes.SphereCoords’>

class openpyxl.drawing.shapes.Path2D(w=None, h=None, fill=None, stroke=None, extrusionOk=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

extrusionOk

Values must be of type <class ‘bool’>

fill

Value must be one of {‘darkenLess’, ‘lightenLess’, ‘lighten’, ‘darken’, ‘norm’}

h

Values must be of type <class ‘float’>

stroke

Values must be of type <class ‘bool’>

w

Values must be of type <class ‘float’>

class openpyxl.drawing.shapes.Path2DList(path=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

path

Values must be of type <class ‘openpyxl.drawing.shapes.Path2D’>

class openpyxl.drawing.shapes.Point2D(x=None, y=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

x

Values must be of type <class ‘int’>

y

Values must be of type <class ‘int’>

class openpyxl.drawing.shapes.Point3D(x=None, y=None, z=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

x

Values must be of type <class ‘openpyxl.descriptors.base.Integer’>

y

Values must be of type <class ‘openpyxl.descriptors.base.Integer’>

z

Values must be of type <class ‘openpyxl.descriptors.base.Integer’>

class openpyxl.drawing.shapes.PositiveSize2D(cx=None, cy=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

Dimensions in EMUs

cx

Values must be of type <class ‘int’>

cy

Values must be of type <class ‘int’>

height

Aliases can be used when either the desired attribute name is not allowed or confusing in Python (eg. “type”) or a more descriptve name is desired (eg. “underline” for “u”)

width

Aliases can be used when either the desired attribute name is not allowed or confusing in Python (eg. “type”) or a more descriptve name is desired (eg. “underline” for “u”)

class openpyxl.drawing.shapes.PresetGeometry2D(prst=None, avLst=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

avLst

Values must be of type <class ‘openpyxl.drawing.shapes.GeomGuideList’>

namespace = 'http://schemas.openxmlformats.org/drawingml/2006/main'

prst

Value must be one of {‘pie’, ‘irregularSeal2’, ‘mathEqual’, ‘curvedConnector3’, ‘roundRect’, ‘curvedConnector2’, ‘flowChartPunchedCard’, ‘trapezoid’, ‘chevron’, ‘flowChartOfflineStorage’, ‘leftRightUpArrow’, ‘flowChartOr’, ‘flowChartDecision’, ‘flowChartOffpageConnector’, ‘flowChartInputOutput’, ‘hexagon’, ‘upArrowCallout’, ‘flowChartCollate’, ‘round2DiagRect’, ‘round2SameRect’, ‘cube’, ‘leftRightArrow’, ‘flowChartDisplay’, ‘accentBorderCallout3’, ‘rightBrace’, ‘borderCallout2’, ‘leftRightRibbon’, ‘octagon’, ‘doubleWave’, ‘flowChartConnector’, ‘homePlate’, ‘leftCircularArrow’, ‘downArrowCallout’, ‘sun’, ‘straightConnector1’, ‘uturnArrow’, ‘flowChartExtract’, ‘swooshArrow’, ‘blockArc’, ‘bentConnector3’, ‘actionButtonHome’, ‘mathPlus’, ‘accentBorderCallout1’, ‘mathMultiply’, ‘leftBrace’, ‘heart’, ‘horizontalScroll’, ‘snip2DiagRect’, ‘actionButtonMovie’, ‘verticalScroll’, ‘star4’, ‘irregularSeal1’, ‘bentConnector5’, ‘flowChartMagneticDrum’, ‘actionButtonSound’, ‘bentConnector4’, ‘flowChartManualInput’, ‘actionButtonForwardNext’, ‘snip2SameRect’, ‘dodecagon’, ‘flowChartMagneticTape’, ‘leftRightArrowCallout’, ‘corner’, ‘cloud’, ‘pentagon’, ‘triangle’, ‘star6’, ‘curvedRightArrow’, ‘rightArrow’, ‘teardrop’, ‘upDownArrow’, ‘star10’, ‘line’, ‘bentUpArrow’, ‘plaque’, ‘ribbon2’, ‘actionButtonBeginning’, ‘flowChartTerminator’, ‘plaqueTabs’, ‘diamond’, ‘flowChartDocument’, ‘leftArrow’, ‘flowChartPunchedTape’, ‘flowChartMerge’, ‘borderCallout1’, ‘can’, ‘gear9’, ‘bentConnector2’, ‘bentArrow’, ‘stripedRightArrow’, ‘donut’, ‘ellipseRibbon’, ‘foldedCorner’, ‘flowChartMagneticDisk’, ‘nonIsoscelesTrapezoid’, ‘curvedDownArrow’, ‘ellipse’, ‘flowChartSummingJunction’, ‘upArrow’, ‘star8’, ‘star7’, ‘arc’, ‘curvedLeftArrow’, ‘actionButtonBackPrevious’, ‘flowChartManualOperation’, ‘accentBorderCallout2’, ‘upDownArrowCallout’, ‘accentCallout3’, ‘rightArrowCallout’, ‘ellipseRibbon2’, ‘pieWedge’, ‘flowChartDelay’, ‘actionButtonEnd’, ‘downArrow’, ‘squareTabs’, ‘chartX’, ‘heptagon’, ‘round1Rect’, ‘funnel’, ‘star32’, ‘flowChartAlternateProcess’, ‘bracketPair’, ‘quadArrowCallout’, ‘gear6’, ‘callout1’, ‘leftRightCircularArrow’, ‘lightningBolt’, ‘diagStripe’, ‘star5’, ‘noSmoking’, ‘wedgeRectCallout’, ‘lineInv’, ‘callout2’, ‘rightBracket’, ‘curvedUpArrow’, ‘mathDivide’, ‘moon’, ‘borderCallout3’, ‘mathMinus’, ‘halfFrame’, ‘flowChartMultidocument’, ‘star24’, ‘wave’, ‘cornerTabs’, ‘chartPlus’, ‘circularArrow’, ‘actionButtonHelp’, ‘curvedConnector4’, ‘ribbon’, ‘flowChartInternalStorage’, ‘star12’, ‘smileyFace’, ‘leftBracket’, ‘leftArrowCallout’, ‘flowChartPreparation’, ‘chartStar’, ‘curvedConnector5’, ‘mathNotEqual’, ‘actionButtonDocument’, ‘frame’, ‘accentCallout1’, ‘cloudCallout’, ‘rect’, ‘actionButtonInformation’, ‘quadArrow’, ‘actionButtonReturn’, ‘wedgeRoundRectCallout’, ‘wedgeEllipseCallout’, ‘parallelogram’, ‘bracePair’, ‘accentCallout2’, ‘flowChartSort’, ‘rtTriangle’, ‘flowChartProcess’, ‘actionButtonBlank’, ‘decagon’, ‘callout3’, ‘bevel’, ‘leftUpArrow’, ‘chord’, ‘snipRoundRect’, ‘star16’, ‘notchedRightArrow’, ‘snip1Rect’, ‘flowChartOnlineStorage’, ‘plus’, ‘flowChartPredefinedProcess’}

class openpyxl.drawing.shapes.Scene3D(camera=None, lightRig=None, backdrop=None, extLst=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

backdrop

Values must be of type <class ‘openpyxl.drawing.shapes.Backdrop’>

camera

Values must be of type <class ‘openpyxl.drawing.shapes.Camera’>

extLst

Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>

lightRig

Values must be of type <class ‘openpyxl.drawing.shapes.LightRig’>

class openpyxl.drawing.shapes.Shape3D(z=None, extrusionH=None, contourW=None, prstMaterial=None, bevelT=None, bevelB=None, extrusionClr=None, contourClr=None, extLst=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

bevelB

Values must be of type <class ‘openpyxl.drawing.shapes.Bevel’>

bevelT

Values must be of type <class ‘openpyxl.drawing.shapes.Bevel’>

contourClr

Values must be of type <class ‘openpyxl.styles.colors.Color’>

contourW

Values must be of type Values must be of type <class ‘int’>

extLst

Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>

extrusionClr

Values must be of type <class ‘openpyxl.styles.colors.Color’>

extrusionH

Values must be of type Values must be of type <class ‘int’>

prstMaterial

Values must be of type <openpyxl.descriptors.base.Set object at 0x7f9578aaa7b8>

z

Values must be of type <class ‘openpyxl.descriptors.base.Integer’>

class openpyxl.drawing.shapes.ShapeStyle(lnRef=None, fillRef=None, effectRef=None, fontRef=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

effectRef

Values must be of type <class ‘openpyxl.drawing.shapes.StyleMatrixReference’>

fillRef

Values must be of type <class ‘openpyxl.drawing.shapes.StyleMatrixReference’>

fontRef

Values must be of type <class ‘openpyxl.drawing.shapes.FontReference’>

lnRef

Values must be of type <class ‘openpyxl.drawing.shapes.StyleMatrixReference’>

class openpyxl.drawing.shapes.SphereCoords(lat=None, lon=None, rev=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

lat

Values must be of type <class ‘openpyxl.descriptors.base.Integer’>

lon

Values must be of type <class ‘openpyxl.descriptors.base.Integer’>

rev

Values must be of type <class ‘openpyxl.descriptors.base.Integer’>

class openpyxl.drawing.shapes.StyleMatrixReference(idx=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

idx

Values must be of type <class ‘int’>

class openpyxl.drawing.shapes.Transform2D(rot=None, flipH=None, flipV=None, off=None, ext=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

ext

Values must be of type <class ‘openpyxl.drawing.shapes.PositiveSize2D’>

flipH

Values must be of type <class ‘bool’>

flipV

Values must be of type <class ‘bool’>

off

Values must be of type <class ‘openpyxl.drawing.shapes.Point2D’>

rot

Values must be of type <class ‘int’>

tagname = 'xfrm'

class openpyxl.drawing.shapes.Vector3D(dx=None, dy=None, dz=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

dx

Values must be of type <class ‘openpyxl.descriptors.base.Integer’>

dy

Values must be of type <class ‘openpyxl.descriptors.base.Integer’>

dz

Values must be of type <class ‘openpyxl.descriptors.base.Integer’>