openpyxl.drawing.fill module

class openpyxl.drawing.fill.Blip(cstate=None, embed=None, link=None, noGrp=None, noSelect=None, noRot=None, noChangeAspect=None, noMove=None, noResize=None, noEditPoints=None, noAdjustHandles=None, noChangeArrowheads=None, noChangeShapeType=None, extLst=None, alphaBiLevel=None, alphaCeiling=None, alphaFloor=None, alphaInv=None, alphaMod=None, alphaModFix=None, alphaRepl=None, biLevel=None, blur=None, clrChange=None, clrRepl=None, duotone=None, fillOverlay=None, grayscl=None, hsl=None, lum=None, tint=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

alphaBiLevel

Values must be of type <class ‘openpyxl.drawing.effect.AlphaBiLevelEffect’>

alphaCeiling

Values must be of type <class ‘openpyxl.drawing.effect.AlphaCeilingEffect’>

alphaFloor

Values must be of type <class ‘openpyxl.drawing.effect.AlphaFloorEffect’>

alphaInv

Values must be of type <class ‘openpyxl.drawing.effect.AlphaInverseEffect’>

alphaMod

Values must be of type <class ‘openpyxl.drawing.effect.AlphaModulateEffect’>

alphaModFix

Values must be of type <class ‘openpyxl.drawing.effect.AlphaModulateFixedEffect’>

alphaRepl

Values must be of type <class ‘openpyxl.drawing.effect.AlphaReplaceEffect’>

biLevel

Values must be of type <class ‘openpyxl.drawing.effect.BiLevelEffect’>

blur

Values must be of type <class ‘openpyxl.drawing.effect.BlurEffect’>

clrChange

Values must be of type <class ‘openpyxl.drawing.effect.ColorChangeEffect’>

clrRepl

Values must be of type <class ‘openpyxl.drawing.effect.ColorReplaceEffect’>

cstate

Value must be one of set([‘print’, ‘hqprint’, ‘screen’, ‘email’])

duotone

Values must be of type <class ‘openpyxl.drawing.effect.DuotoneEffect’>

embed

Values must be of type <type ‘basestring’>

extLst

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

fillOverlay

Values must be of type <class ‘openpyxl.drawing.effect.FillOverlayEffect’>

grayscl

Values must be of type <class ‘openpyxl.drawing.effect.GrayscaleEffect’>

hsl

Values must be of type <class ‘openpyxl.drawing.effect.HSLEffect’>

link

Values must be of type <type ‘basestring’>

lum

Values must be of type <class ‘openpyxl.drawing.effect.LuminanceEffect’>

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

noAdjustHandles

Values must be of type <type ‘bool’>

noChangeArrowheads

Values must be of type <type ‘bool’>

noChangeAspect

Values must be of type <type ‘bool’>

noChangeShapeType

Values must be of type <type ‘bool’>

noEditPoints

Values must be of type <type ‘bool’>

noGrp

Values must be of type <type ‘bool’>

noMove

Values must be of type <type ‘bool’>

noResize

Values must be of type <type ‘bool’>

noRot

Values must be of type <type ‘bool’>

noSelect

Values must be of type <type ‘bool’>

tagname = 'blip'

tint

Values must be of type <class ‘openpyxl.drawing.effect.TintEffect’>

class openpyxl.drawing.fill.BlipFillProperties(dpi=None, rotWithShape=None, blip=None, tile=None, stretch=<openpyxl.drawing.fill.StretchInfoProperties object> Parameters: fillRect=<openpyxl.drawing.fill.RelativeRect object> Parameters: l=None, r=None, t=None, b=None, srcRect=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

blip

Values must be of type <class ‘openpyxl.drawing.fill.Blip’>

dpi

Values must be of type <type ‘long’>

rotWithShape

Values must be of type <type ‘bool’>

srcRect

Values must be of type <class ‘openpyxl.drawing.fill.RelativeRect’>

stretch

Values must be of type <class ‘openpyxl.drawing.fill.StretchInfoProperties’>

tagname = 'blipFill'

tile

Values must be of type <class ‘openpyxl.drawing.fill.TileInfoProperties’>

class openpyxl.drawing.fill.GradientFillProperties(flip=None, rotWithShape=None, gsLst=None, lin=None, path=None, tileRect=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

flip

Value must be one of set([‘y’, ‘x’, ‘xy’])

gsLst

Values must be of type <class ‘openpyxl.drawing.fill.GradientStopList’>

lin

Values must be of type <class ‘openpyxl.drawing.fill.LinearShadeProperties’>

linear

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

path

Values must be of type <class ‘openpyxl.drawing.fill.PathShadeProperties’>

rotWithShape

Values must be of type <type ‘bool’>

stop_list

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

tagname = 'gradFill'

tileRect

Values must be of type <class ‘openpyxl.drawing.fill.RelativeRect’>

class openpyxl.drawing.fill.GradientStop(pos=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

pos

Values must be of type <type ‘float’>

tagname = 'gradStop'

class openpyxl.drawing.fill.GradientStopList(gs=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

gs

A sequence (list or tuple) that may only contain objects of the declared type

tagname = 'gradStopLst'

class openpyxl.drawing.fill.LinearShadeProperties(ang=None, scaled=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

ang

Values must be of type <type ‘long’>

scaled

Values must be of type <type ‘bool’>

class openpyxl.drawing.fill.PathShadeProperties(path=None, fillToRect=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

fillToRect

Values must be of type <class ‘openpyxl.drawing.fill.RelativeRect’>

path

Value must be one of set([‘shape’, ‘circle’, ‘rect’])

class openpyxl.drawing.fill.PatternFillProperties(prst=None, fgClr=None, bgClr=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

background

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

bgClr

Values must be of type <class ‘openpyxl.drawing.colors.ColorChoice’>

fgClr

Values must be of type <class ‘openpyxl.drawing.colors.ColorChoice’>

foreground

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'

preset

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

prst

Value must be one of set([‘lgConfetti’, ‘upDiag’, ‘pct80’, ‘diagBrick’, ‘wave’, ‘smCheck’, ‘dotGrid’, ‘narHorz’, ‘sphere’, ‘zigZag’, ‘horz’, ‘dnDiag’, ‘pct60’, ‘ltHorz’, ‘pct20’, ‘solidDmnd’, ‘pct40’, ‘cross’, ‘lgCheck’, ‘pct25’, ‘horzBrick’, ‘dashHorz’, ‘dashUpDiag’, ‘dkUpDiag’, ‘shingle’, ‘ltDnDiag’, ‘divot’, ‘vert’, ‘dashDnDiag’, ‘narVert’, ‘pct90’, ‘dkVert’, ‘plaid’, ‘dashVert’, ‘smConfetti’, ‘pct10’, ‘ltUpDiag’, ‘wdUpDiag’, ‘dkDnDiag’, ‘wdDnDiag’, ‘diagCross’, ‘weave’, ‘pct75’, ‘lgGrid’, ‘smGrid’, ‘pct50’, ‘pct70’, ‘pct30’, ‘dkHorz’, ‘openDmnd’, ‘dotDmnd’, ‘pct5’, ‘ltVert’, ‘trellis’])

tagname = 'pattFill'

class openpyxl.drawing.fill.RelativeRect(l=None, t=None, r=None, b=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

b

Values must be of type <type ‘float’>

bottom

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

l

Values must be of type <type ‘float’>

left

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'

r

Values must be of type <type ‘float’>

right

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

t

Values must be of type <type ‘float’>

tagname = 'rect'

top

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.fill.StretchInfoProperties(fillRect=<openpyxl.drawing.fill.RelativeRect object> Parameters: l=None, r=None, t=None, b=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

fillRect

Values must be of type <class ‘openpyxl.drawing.fill.RelativeRect’>

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

tagname = 'stretch'

class openpyxl.drawing.fill.TileInfoProperties(tx=None, ty=None, sx=None, sy=None, flip=None, algn=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

algn

Value must be one of set([‘b’, ‘ctr’, ‘bl’, ‘tr’, ‘l’, ‘tl’, ‘r’, ‘t’, ‘br’])

flip

Value must be one of set([‘y’, ‘x’, ‘xy’])

sx

Values must be of type <type ‘long’>

sy

Values must be of type <type ‘long’>

tx

Values must be of type <type ‘long’>

ty

Values must be of type <type ‘long’>