openpyxl.drawing.shapes module

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

Bases: openpyxl.descriptors.serialisable.Serialisable

x

Values must be of type <type ‘long’>

y

Values must be of type <type ‘long’>

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 <type ‘long’>

prst

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

w

Values must be of type Values must be of type <type ‘long’>

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 0x7f1e4c656210>

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 <type ‘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 set([‘major’, ‘minor’])

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

Bases: openpyxl.descriptors.serialisable.Serialisable

fmla

Values must be of type <type ‘basestring’>

name

Values must be of type <type ‘basestring’>

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 <type ‘long’>

l

Values must be of type <type ‘long’>

r

Values must be of type <type ‘long’>

t

Values must be of type <type ‘long’>

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 0x7f1e4c656490>

rig

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

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 <type ‘bool’>

fill

Value must be one of set([‘lighten’, ‘darken’, ‘darkenLess’, ‘lightenLess’, ‘norm’])

h

Values must be of type <type ‘float’>

stroke

Values must be of type <type ‘bool’>

w

Values must be of type <type ‘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 <type ‘long’>

y

Values must be of type <type ‘long’>

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 <type ‘long’>

cy

Values must be of type <type ‘long’>

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

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 <type ‘long’>

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 <type ‘long’>

prstMaterial

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

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 <type ‘long’>

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 <type ‘bool’>

flipV

Values must be of type <type ‘bool’>

off

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

rot

Values must be of type <type ‘long’>

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’>