openpyxl.drawing.geometry module

class openpyxl.drawing.geometry.AdjPoint2D(x=None, y=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

x

Values must be of type <class ‘int’>

y

Values must be of type <class ‘int’>

class openpyxl.drawing.geometry.AdjustHandleList[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

class openpyxl.drawing.geometry.Backdrop(anchor=None, norm=None, up=None, extLst=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

anchor

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

extLst

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

norm

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

up

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

class openpyxl.drawing.geometry.Bevel(w=None, h=None, prst=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

h

Values must be of type <class ‘int’>

prst

Value must be one of {‘softRound’, ‘coolSlant’, ‘slope’, ‘relaxedInset’, ‘hardEdge’, ‘convex’, ‘artDeco’, ‘riblet’, ‘divot’, ‘angle’, ‘cross’, ‘circle’}

tagname = 'bevel'
w

Values must be of type <class ‘int’>

class openpyxl.drawing.geometry.Camera(prst=None, fov=None, zoom=None, rot=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

fov

Values must be of type <class ‘int’>

prst

Value must be one of {‘legacyObliqueBottomRight’, ‘legacyPerspectiveLeft’, ‘isometricOffAxis1Right’, ‘perspectiveContrastingRightFacing’, ‘legacyPerspectiveBottomLeft’, ‘legacyObliqueFront’, ‘isometricOffAxis4Right’, ‘legacyObliqueLeft’, ‘isometricBottomDown’, ‘perspectiveFront’, ‘perspectiveBelow’, ‘legacyPerspectiveRight’, ‘isometricOffAxis3Left’, ‘perspectiveAboveLeftFacing’, ‘isometricOffAxis3Right’, ‘legacyObliqueBottomLeft’, ‘perspectiveRight’, ‘obliqueTop’, ‘obliqueTopRight’, ‘isometricTopUp’, ‘perspectiveAboveRightFacing’, ‘isometricOffAxis1Top’, ‘perspectiveHeroicExtremeRightFacing’, ‘isometricLeftDown’, ‘legacyObliqueTopRight’, ‘isometricTopDown’, ‘isometricOffAxis2Right’, ‘legacyPerspectiveBottomRight’, ‘obliqueTopLeft’, ‘perspectiveContrastingLeftFacing’, ‘perspectiveHeroicRightFacing’, ‘legacyObliqueBottom’, ‘isometricOffAxis1Left’, ‘isometricRightUp’, ‘legacyObliqueTopLeft’, ‘obliqueBottomRight’, ‘legacyObliqueRight’, ‘orthographicFront’, ‘perspectiveRelaxedModerately’, ‘isometricRightDown’, ‘isometricOffAxis4Left’, ‘obliqueBottom’, ‘isometricOffAxis2Left’, ‘legacyObliqueTop’, ‘perspectiveLeft’, ‘legacyPerspectiveTopLeft’, ‘isometricOffAxis3Bottom’, ‘isometricOffAxis2Top’, ‘perspectiveRelaxed’, ‘legacyPerspectiveBottom’, ‘legacyPerspectiveFront’, ‘isometricOffAxis4Bottom’, ‘legacyPerspectiveTopRight’, ‘obliqueLeft’, ‘obliqueBottomLeft’, ‘obliqueRight’, ‘isometricLeftUp’, ‘perspectiveAbove’, ‘legacyPerspectiveTop’, ‘perspectiveHeroicLeftFacing’, ‘perspectiveHeroicExtremeLeftFacing’, ‘isometricBottomUp’}

rot

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

tagname = 'camera'
zoom

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

class openpyxl.drawing.geometry.ConnectionSite(ang=None, pos=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

ang

Values must be of type <class ‘float’>

pos

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

class openpyxl.drawing.geometry.ConnectionSiteList(cxn=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

cxn

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

class openpyxl.drawing.geometry.CustomGeometry2D(avLst=None, gdLst=None, ahLst=None, cxnLst=None, rect=None, pathLst=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

ahLst

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

avLst

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

cxnLst

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

gdLst

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

pathLst

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

rect

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

class openpyxl.drawing.geometry.FontReference(idx=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

idx

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

class openpyxl.drawing.geometry.GeomGuide(name=None, fmla=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

fmla

Values must be of type <class ‘str’>

name

Values must be of type <class ‘str’>

class openpyxl.drawing.geometry.GeomGuideList(gd=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

gd

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

class openpyxl.drawing.geometry.GeomRect(l=None, t=None, r=None, b=None)[source]

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.geometry.GroupTransform2D(rot=0, flipH=None, flipV=None, off=None, ext=None, chOff=None, chExt=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

chExt

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

chOff

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

ext

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

flipH

Values must be of type <class ‘bool’>

flipV

Values must be of type <class ‘bool’>

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

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

rot

Values must be of type <class ‘int’>

tagname = 'xfrm'
class openpyxl.drawing.geometry.LightRig(rig=None, dir=None, rot=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

dir

Value must be one of {‘br’, ‘tr’, ‘r’, ‘bl’, ‘tl’, ‘l’, ‘b’, ‘t’}

rig

Value must be one of {‘harsh’, ‘legacyHarsh1’, ‘legacyFlat4’, ‘legacyNormal4’, ‘morning’, ‘legacyNormal3’, ‘flat’, ‘sunset’, ‘sunrise’, ‘legacyFlat3’, ‘soft’, ‘legacyNormal2’, ‘flood’, ‘balanced’, ‘legacyFlat2’, ‘brightRoom’, ‘glow’, ‘legacyHarsh3’, ‘legacyHarsh2’, ‘chilly’, ‘contrasting’, ‘legacyFlat1’, ‘freezing’, ‘legacyNormal1’, ‘threePt’, ‘twoPt’, ‘legacyHarsh4’}

rot

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

tagname = 'lightRig'
class openpyxl.drawing.geometry.Path2D(w=None, h=None, fill=None, stroke=None, extrusionOk=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

extrusionOk

Values must be of type <class ‘bool’>

fill

Value must be one of {‘lighten’, ‘darkenLess’, ‘darken’, ‘lightenLess’, ‘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.geometry.Path2DList(path=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

path

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

class openpyxl.drawing.geometry.Point2D(x=None, y=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

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

Values must be of type <class ‘int’>

y

Values must be of type <class ‘int’>

class openpyxl.drawing.geometry.Point3D(x=None, y=None, z=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

tagname = 'anchor'
x

Values must be of type <class ‘int’>

y

Values must be of type <class ‘int’>

z

Values must be of type <class ‘int’>

class openpyxl.drawing.geometry.PositiveSize2D(cx=None, cy=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

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”)

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

Dimensions in EMUs

tagname = 'ext'
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.geometry.PresetGeometry2D(prst=None, avLst=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

avLst

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

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

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

class openpyxl.drawing.geometry.Scene3D(camera=None, lightRig=None, backdrop=None, extLst=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

backdrop

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

camera

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

extLst

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

lightRig

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

class openpyxl.drawing.geometry.Shape3D(z=None, extrusionH=None, contourW=None, prstMaterial=None, bevelT=None, bevelB=None, extrusionClr=None, contourClr=None, extLst=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

bevelB

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

bevelT

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

contourClr

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

contourW

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 <class ‘int’>

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

Value must be one of {‘flat’, ‘matte’, ‘translucentPowder’, ‘clear’, ‘softEdge’, ‘legacyMetal’, ‘legacyPlastic’, ‘plastic’, ‘powder’, ‘dkEdge’, ‘legacyWireframe’, ‘legacyMatte’, ‘warmMatte’, ‘softmetal’, ‘metal’}

z

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

class openpyxl.drawing.geometry.ShapeStyle(lnRef=None, fillRef=None, effectRef=None, fontRef=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

effectRef

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

fillRef

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

fontRef

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

lnRef

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

class openpyxl.drawing.geometry.SphereCoords(lat=None, lon=None, rev=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

lat

Values must be of type <class ‘int’>

lon

Values must be of type <class ‘int’>

rev

Values must be of type <class ‘int’>

tagname = 'sphereCoords'
class openpyxl.drawing.geometry.StyleMatrixReference(idx=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

idx

Values must be of type <class ‘int’>

class openpyxl.drawing.geometry.Transform2D(rot=None, flipH=None, flipV=None, off=None, ext=None, chOff=None, chExt=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

chExt

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

chOff

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

ext

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

flipH

Values must be of type <class ‘bool’>

flipV

Values must be of type <class ‘bool’>

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

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

rot

Values must be of type <class ‘int’>

tagname = 'xfrm'
class openpyxl.drawing.geometry.Vector3D(dx=None, dy=None, dz=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

dx

Values must be of type <class ‘int’>

dy

Values must be of type <class ‘int’>

dz

Values must be of type <class ‘int’>

tagname = 'vector'