openpyxl.drawing.effect module

class openpyxl.drawing.effect.AlphaBiLevelEffect(thresh=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

thresh

Values must be of type <class ‘int’>

class openpyxl.drawing.effect.AlphaCeilingEffect[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

class openpyxl.drawing.effect.AlphaFloorEffect[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

class openpyxl.drawing.effect.AlphaInverseEffect[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

class openpyxl.drawing.effect.AlphaModulateEffect(cont=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

cont

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

class openpyxl.drawing.effect.AlphaModulateFixedEffect(amt=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

amt

Values must be of type <class ‘int’>

class openpyxl.drawing.effect.AlphaReplaceEffect(a=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

a

Values must be of type <class ‘int’>

class openpyxl.drawing.effect.BiLevelEffect(thresh=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

thresh

Values must be of type <class ‘int’>

class openpyxl.drawing.effect.BlurEffect(rad=None, grow=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

grow

Values must be of type <class ‘bool’>

rad

Values must be of type <class ‘float’>

class openpyxl.drawing.effect.Color[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

class openpyxl.drawing.effect.ColorChangeEffect(useA=None, clrFrom=None, clrTo=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

clrFrom

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

clrTo

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

useA

Values must be of type <class ‘bool’>

class openpyxl.drawing.effect.ColorReplaceEffect[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

class openpyxl.drawing.effect.DuotoneEffect[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

class openpyxl.drawing.effect.EffectContainer(type=None, name=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

name

Values must be of type <class ‘str’>

type

Value must be one of {‘sib’, ‘tree’}

class openpyxl.drawing.effect.EffectList(blur=None, fillOverlay=None, glow=None, innerShdw=None, outerShdw=None, prstShdw=None, reflection=None, softEdge=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

blur

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

fillOverlay

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

glow

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

innerShdw

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

outerShdw

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

prstShdw

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

reflection

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

softEdge

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

class openpyxl.drawing.effect.FillOverlayEffect(blend=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

blend

Value must be one of {‘screen’, ‘mult’, ‘over’, ‘darken’, ‘lighten’}

class openpyxl.drawing.effect.GlowEffect(rad=None, **kw)[source]

Bases: openpyxl.drawing.colors.ColorChoice

hslClr

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

prstClr

Value must be one of {‘ltSlateGrey’, ‘medBlue’, ‘mediumSeaGreen’, ‘skyBlue’, ‘darkGray’, ‘lightSlateGrey’, ‘darkOrange’, ‘dimGrey’, ‘ghostWhite’, ‘ltBlue’, ‘lightCoral’, ‘dkCyan’, ‘navajoWhite’, ‘midnightBlue’, ‘greenYellow’, ‘medOrchid’, ‘floralWhite’, ‘honeydew’, ‘darkSalmon’, ‘slateGrey’, ‘dkKhaki’, ‘navy’, ‘ltSteelBlue’, ‘medSeaGreen’, ‘seaShell’, ‘thistle’, ‘powderBlue’, ‘tan’, ‘pink’, ‘lime’, ‘dkTurquoise’, ‘darkGoldenrod’, ‘ltYellow’, ‘brown’, ‘magenta’, ‘mediumAquamarine’, ‘medTurquoise’, ‘antiqueWhite’, ‘darkOliveGreen’, ‘chartreuse’, ‘darkSlateGrey’, ‘lightGoldenrodYellow’, ‘medPurple’, ‘dkBlue’, ‘cadetBlue’, ‘grey’, ‘ltSlateGray’, ‘paleGoldenrod’, ‘maroon’, ‘dkSlateGray’, ‘sandyBrown’, ‘mediumTurquoise’, ‘ltCyan’, ‘mediumSlateBlue’, ‘lavender’, ‘wheat’, ‘darkSeaGreen’, ‘medVioletRed’, ‘darkGreen’, ‘mistyRose’, ‘snow’, ‘ltCoral’, ‘red’, ‘lavenderBlush’, ‘lightGreen’, ‘cyan’, ‘dkGreen’, ‘ltSkyBlue’, ‘rosyBrown’, ‘royalBlue’, ‘ltSalmon’, ‘slateGray’, ‘lightYellow’, ‘teal’, ‘papayaWhip’, ‘lightSkyBlue’, ‘darkViolet’, ‘bisque’, ‘medSlateBlue’, ‘cornflowerBlue’, ‘lightSalmon’, ‘ivory’, ‘dkMagenta’, ‘lightPink’, ‘lemonChiffon’, ‘mintCream’, ‘lightSlateGray’, ‘slateBlue’, ‘ltGoldenrodYellow’, ‘darkSlateBlue’, ‘mediumBlue’, ‘dkGrey’, ‘blanchedAlmond’, ‘dkSalmon’, ‘lawnGreen’, ‘whiteSmoke’, ‘lightCyan’, ‘ltSeaGreen’, ‘aquamarine’, ‘lightSteelBlue’, ‘aliceBlue’, ‘darkGrey’, ‘lightSeaGreen’, ‘black’, ‘paleGreen’, ‘yellow’, ‘dodgerBlue’, ‘indianRed’, ‘beige’, ‘hotPink’, ‘orangeRed’, ‘dkGray’, ‘dkSlateGrey’, ‘sienna’, ‘steelBlue’, ‘moccasin’, ‘gray’, ‘paleVioletRed’, ‘springGreen’, ‘medAquamarine’, ‘plum’, ‘oldLace’, ‘lightGray’, ‘paleTurquoise’, ‘seaGreen’, ‘orange’, ‘ltGrey’, ‘ltPink’, ‘yellowGreen’, ‘mediumPurple’, ‘green’, ‘dkOrchid’, ‘mediumOrchid’, ‘darkCyan’, ‘cornsilk’, ‘darkTurquoise’, ‘goldenrod’, ‘chocolate’, ‘darkSlateGray’, ‘forestGreen’, ‘aqua’, ‘gold’, ‘darkKhaki’, ‘saddleBrown’, ‘olive’, ‘deepPink’, ‘oliveDrab’, ‘azure’, ‘fuchsia’, ‘peachPuff’, ‘purple’, ‘mediumVioletRed’, ‘dkOrange’, ‘dkOliveGreen’, ‘orchid’, ‘tomato’, ‘burlyWood’, ‘ltGray’, ‘turquoise’, ‘dkGoldenrod’, ‘limeGreen’, ‘gainsboro’, ‘medSpringGreen’, ‘darkMagenta’, ‘darkRed’, ‘crimson’, ‘dkSeaGreen’, ‘blueViolet’, ‘violet’, ‘dkRed’, ‘linen’, ‘blue’, ‘darkBlue’, ‘ltGreen’, ‘mediumSpringGreen’, ‘peru’, ‘indigo’, ‘dimGray’, ‘deepSkyBlue’, ‘darkOrchid’, ‘coral’, ‘lightGrey’, ‘dkViolet’, ‘dkSlateBlue’, ‘firebrick’, ‘khaki’, ‘lightBlue’, ‘silver’, ‘white’, ‘salmon’}

rad

Values must be of type <class ‘float’>

schemeClr

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

scrgbClr

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

srgbClr

Values must be of type <class ‘str’>

sysClr

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

class openpyxl.drawing.effect.GrayscaleEffect[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

class openpyxl.drawing.effect.HSLEffect(hue=None, sat=None, lum=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

hue

Values must be of type <class ‘int’>

lum

Values must be of type <class ‘int’>

sat

Values must be of type <class ‘int’>

class openpyxl.drawing.effect.InnerShadowEffect(blurRad=None, dist=None, dir=None, **kw)[source]

Bases: openpyxl.drawing.colors.ColorChoice

blurRad

Values must be of type <class ‘float’>

dir

Values must be of type <class ‘int’>

dist

Values must be of type <class ‘float’>

hslClr

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

prstClr

Value must be one of {‘ltSlateGrey’, ‘medBlue’, ‘mediumSeaGreen’, ‘skyBlue’, ‘darkGray’, ‘lightSlateGrey’, ‘darkOrange’, ‘dimGrey’, ‘ghostWhite’, ‘ltBlue’, ‘lightCoral’, ‘dkCyan’, ‘navajoWhite’, ‘midnightBlue’, ‘greenYellow’, ‘medOrchid’, ‘floralWhite’, ‘honeydew’, ‘darkSalmon’, ‘slateGrey’, ‘dkKhaki’, ‘navy’, ‘ltSteelBlue’, ‘medSeaGreen’, ‘seaShell’, ‘thistle’, ‘powderBlue’, ‘tan’, ‘pink’, ‘lime’, ‘dkTurquoise’, ‘darkGoldenrod’, ‘ltYellow’, ‘brown’, ‘magenta’, ‘mediumAquamarine’, ‘medTurquoise’, ‘antiqueWhite’, ‘darkOliveGreen’, ‘chartreuse’, ‘darkSlateGrey’, ‘lightGoldenrodYellow’, ‘medPurple’, ‘dkBlue’, ‘cadetBlue’, ‘grey’, ‘ltSlateGray’, ‘paleGoldenrod’, ‘maroon’, ‘dkSlateGray’, ‘sandyBrown’, ‘mediumTurquoise’, ‘ltCyan’, ‘mediumSlateBlue’, ‘lavender’, ‘wheat’, ‘darkSeaGreen’, ‘medVioletRed’, ‘darkGreen’, ‘mistyRose’, ‘snow’, ‘ltCoral’, ‘red’, ‘lavenderBlush’, ‘lightGreen’, ‘cyan’, ‘dkGreen’, ‘ltSkyBlue’, ‘rosyBrown’, ‘royalBlue’, ‘ltSalmon’, ‘slateGray’, ‘lightYellow’, ‘teal’, ‘papayaWhip’, ‘lightSkyBlue’, ‘darkViolet’, ‘bisque’, ‘medSlateBlue’, ‘cornflowerBlue’, ‘lightSalmon’, ‘ivory’, ‘dkMagenta’, ‘lightPink’, ‘lemonChiffon’, ‘mintCream’, ‘lightSlateGray’, ‘slateBlue’, ‘ltGoldenrodYellow’, ‘darkSlateBlue’, ‘mediumBlue’, ‘dkGrey’, ‘blanchedAlmond’, ‘dkSalmon’, ‘lawnGreen’, ‘whiteSmoke’, ‘lightCyan’, ‘ltSeaGreen’, ‘aquamarine’, ‘lightSteelBlue’, ‘aliceBlue’, ‘darkGrey’, ‘lightSeaGreen’, ‘black’, ‘paleGreen’, ‘yellow’, ‘dodgerBlue’, ‘indianRed’, ‘beige’, ‘hotPink’, ‘orangeRed’, ‘dkGray’, ‘dkSlateGrey’, ‘sienna’, ‘steelBlue’, ‘moccasin’, ‘gray’, ‘paleVioletRed’, ‘springGreen’, ‘medAquamarine’, ‘plum’, ‘oldLace’, ‘lightGray’, ‘paleTurquoise’, ‘seaGreen’, ‘orange’, ‘ltGrey’, ‘ltPink’, ‘yellowGreen’, ‘mediumPurple’, ‘green’, ‘dkOrchid’, ‘mediumOrchid’, ‘darkCyan’, ‘cornsilk’, ‘darkTurquoise’, ‘goldenrod’, ‘chocolate’, ‘darkSlateGray’, ‘forestGreen’, ‘aqua’, ‘gold’, ‘darkKhaki’, ‘saddleBrown’, ‘olive’, ‘deepPink’, ‘oliveDrab’, ‘azure’, ‘fuchsia’, ‘peachPuff’, ‘purple’, ‘mediumVioletRed’, ‘dkOrange’, ‘dkOliveGreen’, ‘orchid’, ‘tomato’, ‘burlyWood’, ‘ltGray’, ‘turquoise’, ‘dkGoldenrod’, ‘limeGreen’, ‘gainsboro’, ‘medSpringGreen’, ‘darkMagenta’, ‘darkRed’, ‘crimson’, ‘dkSeaGreen’, ‘blueViolet’, ‘violet’, ‘dkRed’, ‘linen’, ‘blue’, ‘darkBlue’, ‘ltGreen’, ‘mediumSpringGreen’, ‘peru’, ‘indigo’, ‘dimGray’, ‘deepSkyBlue’, ‘darkOrchid’, ‘coral’, ‘lightGrey’, ‘dkViolet’, ‘dkSlateBlue’, ‘firebrick’, ‘khaki’, ‘lightBlue’, ‘silver’, ‘white’, ‘salmon’}

schemeClr

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

scrgbClr

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

srgbClr

Values must be of type <class ‘str’>

sysClr

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

class openpyxl.drawing.effect.LuminanceEffect(bright=None, contrast=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

bright

Values must be of type <class ‘int’>

contrast

Values must be of type <class ‘int’>

class openpyxl.drawing.effect.OuterShadow(blurRad=None, dist=None, dir=None, sx=None, sy=None, kx=None, ky=None, algn=None, rotWithShape=None, **kw)[source]

Bases: openpyxl.drawing.colors.ColorChoice

algn

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

blurRad

Values must be of type <class ‘float’>

dir

Values must be of type <class ‘int’>

dist

Values must be of type <class ‘float’>

hslClr

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

kx

Values must be of type <class ‘int’>

ky

Values must be of type <class ‘int’>

prstClr

Value must be one of {‘ltSlateGrey’, ‘medBlue’, ‘mediumSeaGreen’, ‘skyBlue’, ‘darkGray’, ‘lightSlateGrey’, ‘darkOrange’, ‘dimGrey’, ‘ghostWhite’, ‘ltBlue’, ‘lightCoral’, ‘dkCyan’, ‘navajoWhite’, ‘midnightBlue’, ‘greenYellow’, ‘medOrchid’, ‘floralWhite’, ‘honeydew’, ‘darkSalmon’, ‘slateGrey’, ‘dkKhaki’, ‘navy’, ‘ltSteelBlue’, ‘medSeaGreen’, ‘seaShell’, ‘thistle’, ‘powderBlue’, ‘tan’, ‘pink’, ‘lime’, ‘dkTurquoise’, ‘darkGoldenrod’, ‘ltYellow’, ‘brown’, ‘magenta’, ‘mediumAquamarine’, ‘medTurquoise’, ‘antiqueWhite’, ‘darkOliveGreen’, ‘chartreuse’, ‘darkSlateGrey’, ‘lightGoldenrodYellow’, ‘medPurple’, ‘dkBlue’, ‘cadetBlue’, ‘grey’, ‘ltSlateGray’, ‘paleGoldenrod’, ‘maroon’, ‘dkSlateGray’, ‘sandyBrown’, ‘mediumTurquoise’, ‘ltCyan’, ‘mediumSlateBlue’, ‘lavender’, ‘wheat’, ‘darkSeaGreen’, ‘medVioletRed’, ‘darkGreen’, ‘mistyRose’, ‘snow’, ‘ltCoral’, ‘red’, ‘lavenderBlush’, ‘lightGreen’, ‘cyan’, ‘dkGreen’, ‘ltSkyBlue’, ‘rosyBrown’, ‘royalBlue’, ‘ltSalmon’, ‘slateGray’, ‘lightYellow’, ‘teal’, ‘papayaWhip’, ‘lightSkyBlue’, ‘darkViolet’, ‘bisque’, ‘medSlateBlue’, ‘cornflowerBlue’, ‘lightSalmon’, ‘ivory’, ‘dkMagenta’, ‘lightPink’, ‘lemonChiffon’, ‘mintCream’, ‘lightSlateGray’, ‘slateBlue’, ‘ltGoldenrodYellow’, ‘darkSlateBlue’, ‘mediumBlue’, ‘dkGrey’, ‘blanchedAlmond’, ‘dkSalmon’, ‘lawnGreen’, ‘whiteSmoke’, ‘lightCyan’, ‘ltSeaGreen’, ‘aquamarine’, ‘lightSteelBlue’, ‘aliceBlue’, ‘darkGrey’, ‘lightSeaGreen’, ‘black’, ‘paleGreen’, ‘yellow’, ‘dodgerBlue’, ‘indianRed’, ‘beige’, ‘hotPink’, ‘orangeRed’, ‘dkGray’, ‘dkSlateGrey’, ‘sienna’, ‘steelBlue’, ‘moccasin’, ‘gray’, ‘paleVioletRed’, ‘springGreen’, ‘medAquamarine’, ‘plum’, ‘oldLace’, ‘lightGray’, ‘paleTurquoise’, ‘seaGreen’, ‘orange’, ‘ltGrey’, ‘ltPink’, ‘yellowGreen’, ‘mediumPurple’, ‘green’, ‘dkOrchid’, ‘mediumOrchid’, ‘darkCyan’, ‘cornsilk’, ‘darkTurquoise’, ‘goldenrod’, ‘chocolate’, ‘darkSlateGray’, ‘forestGreen’, ‘aqua’, ‘gold’, ‘darkKhaki’, ‘saddleBrown’, ‘olive’, ‘deepPink’, ‘oliveDrab’, ‘azure’, ‘fuchsia’, ‘peachPuff’, ‘purple’, ‘mediumVioletRed’, ‘dkOrange’, ‘dkOliveGreen’, ‘orchid’, ‘tomato’, ‘burlyWood’, ‘ltGray’, ‘turquoise’, ‘dkGoldenrod’, ‘limeGreen’, ‘gainsboro’, ‘medSpringGreen’, ‘darkMagenta’, ‘darkRed’, ‘crimson’, ‘dkSeaGreen’, ‘blueViolet’, ‘violet’, ‘dkRed’, ‘linen’, ‘blue’, ‘darkBlue’, ‘ltGreen’, ‘mediumSpringGreen’, ‘peru’, ‘indigo’, ‘dimGray’, ‘deepSkyBlue’, ‘darkOrchid’, ‘coral’, ‘lightGrey’, ‘dkViolet’, ‘dkSlateBlue’, ‘firebrick’, ‘khaki’, ‘lightBlue’, ‘silver’, ‘white’, ‘salmon’}

rotWithShape

Values must be of type <class ‘bool’>

schemeClr

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

scrgbClr

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

srgbClr

Values must be of type <class ‘str’>

sx

Values must be of type <class ‘int’>

sy

Values must be of type <class ‘int’>

sysClr

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

tagname = 'outerShdw'
class openpyxl.drawing.effect.PresetShadowEffect(prst=None, dist=None, dir=None, **kw)[source]

Bases: openpyxl.drawing.colors.ColorChoice

dir

Values must be of type <class ‘int’>

dist

Values must be of type <class ‘float’>

hslClr

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

prst

Value must be one of {‘shdw5’, ‘shdw3’, ‘shdw13’, ‘shdw9’, ‘shdw10’, ‘shdw18’, ‘shdw15’, ‘shdw1’, ‘shdw16’, ‘shdw7’, ‘shdw8’, ‘shdw17’, ‘shdw19’, ‘shdw6’, ‘shdw20’, ‘shdw12’, ‘shdw11’, ‘shdw14’, ‘shdw2’, ‘shdw4’}

prstClr

Value must be one of {‘ltSlateGrey’, ‘medBlue’, ‘mediumSeaGreen’, ‘skyBlue’, ‘darkGray’, ‘lightSlateGrey’, ‘darkOrange’, ‘dimGrey’, ‘ghostWhite’, ‘ltBlue’, ‘lightCoral’, ‘dkCyan’, ‘navajoWhite’, ‘midnightBlue’, ‘greenYellow’, ‘medOrchid’, ‘floralWhite’, ‘honeydew’, ‘darkSalmon’, ‘slateGrey’, ‘dkKhaki’, ‘navy’, ‘ltSteelBlue’, ‘medSeaGreen’, ‘seaShell’, ‘thistle’, ‘powderBlue’, ‘tan’, ‘pink’, ‘lime’, ‘dkTurquoise’, ‘darkGoldenrod’, ‘ltYellow’, ‘brown’, ‘magenta’, ‘mediumAquamarine’, ‘medTurquoise’, ‘antiqueWhite’, ‘darkOliveGreen’, ‘chartreuse’, ‘darkSlateGrey’, ‘lightGoldenrodYellow’, ‘medPurple’, ‘dkBlue’, ‘cadetBlue’, ‘grey’, ‘ltSlateGray’, ‘paleGoldenrod’, ‘maroon’, ‘dkSlateGray’, ‘sandyBrown’, ‘mediumTurquoise’, ‘ltCyan’, ‘mediumSlateBlue’, ‘lavender’, ‘wheat’, ‘darkSeaGreen’, ‘medVioletRed’, ‘darkGreen’, ‘mistyRose’, ‘snow’, ‘ltCoral’, ‘red’, ‘lavenderBlush’, ‘lightGreen’, ‘cyan’, ‘dkGreen’, ‘ltSkyBlue’, ‘rosyBrown’, ‘royalBlue’, ‘ltSalmon’, ‘slateGray’, ‘lightYellow’, ‘teal’, ‘papayaWhip’, ‘lightSkyBlue’, ‘darkViolet’, ‘bisque’, ‘medSlateBlue’, ‘cornflowerBlue’, ‘lightSalmon’, ‘ivory’, ‘dkMagenta’, ‘lightPink’, ‘lemonChiffon’, ‘mintCream’, ‘lightSlateGray’, ‘slateBlue’, ‘ltGoldenrodYellow’, ‘darkSlateBlue’, ‘mediumBlue’, ‘dkGrey’, ‘blanchedAlmond’, ‘dkSalmon’, ‘lawnGreen’, ‘whiteSmoke’, ‘lightCyan’, ‘ltSeaGreen’, ‘aquamarine’, ‘lightSteelBlue’, ‘aliceBlue’, ‘darkGrey’, ‘lightSeaGreen’, ‘black’, ‘paleGreen’, ‘yellow’, ‘dodgerBlue’, ‘indianRed’, ‘beige’, ‘hotPink’, ‘orangeRed’, ‘dkGray’, ‘dkSlateGrey’, ‘sienna’, ‘steelBlue’, ‘moccasin’, ‘gray’, ‘paleVioletRed’, ‘springGreen’, ‘medAquamarine’, ‘plum’, ‘oldLace’, ‘lightGray’, ‘paleTurquoise’, ‘seaGreen’, ‘orange’, ‘ltGrey’, ‘ltPink’, ‘yellowGreen’, ‘mediumPurple’, ‘green’, ‘dkOrchid’, ‘mediumOrchid’, ‘darkCyan’, ‘cornsilk’, ‘darkTurquoise’, ‘goldenrod’, ‘chocolate’, ‘darkSlateGray’, ‘forestGreen’, ‘aqua’, ‘gold’, ‘darkKhaki’, ‘saddleBrown’, ‘olive’, ‘deepPink’, ‘oliveDrab’, ‘azure’, ‘fuchsia’, ‘peachPuff’, ‘purple’, ‘mediumVioletRed’, ‘dkOrange’, ‘dkOliveGreen’, ‘orchid’, ‘tomato’, ‘burlyWood’, ‘ltGray’, ‘turquoise’, ‘dkGoldenrod’, ‘limeGreen’, ‘gainsboro’, ‘medSpringGreen’, ‘darkMagenta’, ‘darkRed’, ‘crimson’, ‘dkSeaGreen’, ‘blueViolet’, ‘violet’, ‘dkRed’, ‘linen’, ‘blue’, ‘darkBlue’, ‘ltGreen’, ‘mediumSpringGreen’, ‘peru’, ‘indigo’, ‘dimGray’, ‘deepSkyBlue’, ‘darkOrchid’, ‘coral’, ‘lightGrey’, ‘dkViolet’, ‘dkSlateBlue’, ‘firebrick’, ‘khaki’, ‘lightBlue’, ‘silver’, ‘white’, ‘salmon’}

schemeClr

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

scrgbClr

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

srgbClr

Values must be of type <class ‘str’>

sysClr

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

class openpyxl.drawing.effect.ReflectionEffect(blurRad=None, stA=None, stPos=None, endA=None, endPos=None, dist=None, dir=None, fadeDir=None, sx=None, sy=None, kx=None, ky=None, algn=None, rotWithShape=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

algn

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

blurRad

Values must be of type <class ‘float’>

dir

Values must be of type <class ‘int’>

dist

Values must be of type <class ‘float’>

endA

Values must be of type <class ‘int’>

endPos

Values must be of type <class ‘int’>

fadeDir

Values must be of type <class ‘int’>

kx

Values must be of type <class ‘int’>

ky

Values must be of type <class ‘int’>

rotWithShape

Values must be of type <class ‘bool’>

stA

Values must be of type <class ‘int’>

stPos

Values must be of type <class ‘int’>

sx

Values must be of type <class ‘int’>

sy

Values must be of type <class ‘int’>

class openpyxl.drawing.effect.SoftEdgesEffect(rad=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

rad

Values must be of type <class ‘float’>

class openpyxl.drawing.effect.TintEffect(hue=None, amt=None)[source]

Bases: openpyxl.descriptors.serialisable.Serialisable

amt

Values must be of type <class ‘int’>

hue

Values must be of type <class ‘int’>