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.
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.
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.
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.OuterShadowEffect’>
-
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 {‘darken’, ‘over’, ‘mult’, ‘screen’, ‘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 {‘ltYellow’, ‘dkBlue’, ‘dkSlateGray’, ‘dkSalmon’, ‘silver’, ‘darkSlateBlue’, ‘maroon’, ‘orangeRed’, ‘lightCoral’, ‘burlyWood’, ‘darkOrange’, ‘mediumSpringGreen’, ‘teal’, ‘darkOliveGreen’, ‘beige’, ‘oldLace’, ‘khaki’, ‘limeGreen’, ‘whiteSmoke’, ‘darkGoldenrod’, ‘slateGrey’, ‘black’, ‘olive’, ‘lavender’, ‘tomato’, ‘darkCyan’, ‘lawnGreen’, ‘linen’, ‘darkKhaki’, ‘medSlateBlue’, ‘dkGoldenrod’, ‘seaShell’, ‘dkSlateBlue’, ‘tan’, ‘saddleBrown’, ‘paleGoldenrod’, ‘medSpringGreen’, ‘deepSkyBlue’, ‘dkGrey’, ‘medAquamarine’, ‘gray’, ‘navajoWhite’, ‘mediumSeaGreen’, ‘medBlue’, ‘lightBlue’, ‘magenta’, ‘ltGrey’, ‘indianRed’, ‘cadetBlue’, ‘dkOrange’, ‘deepPink’, ‘green’, ‘lightYellow’, ‘ltPink’, ‘dkMagenta’, ‘ltSalmon’, ‘darkOrchid’, ‘hotPink’, ‘azure’, ‘indigo’, ‘purple’, ‘sienna’, ‘ltSlateGrey’, ‘red’, ‘moccasin’, ‘dkTurquoise’, ‘ltSlateGray’, ‘antiqueWhite’, ‘blue’, ‘ltSteelBlue’, ‘powderBlue’, ‘gainsboro’, ‘white’, ‘thistle’, ‘midnightBlue’, ‘chartreuse’, ‘darkTurquoise’, ‘pink’, ‘peachPuff’, ‘lightSeaGreen’, ‘dkOliveGreen’, ‘lightGray’, ‘mediumBlue’, ‘peru’, ‘ltGreen’, ‘plum’, ‘sandyBrown’, ‘dkKhaki’, ‘cyan’, ‘yellow’, ‘mediumOrchid’, ‘lightSlateGray’, ‘paleVioletRed’, ‘lightSalmon’, ‘lightSlateGrey’, ‘medPurple’, ‘mediumVioletRed’, ‘darkSeaGreen’, ‘lavenderBlush’, ‘yellowGreen’, ‘ltBlue’, ‘dimGrey’, ‘dodgerBlue’, ‘lightGoldenrodYellow’, ‘springGreen’, ‘chocolate’, ‘orchid’, ‘aquamarine’, ‘darkSalmon’, ‘crimson’, ‘ltSeaGreen’, ‘medSeaGreen’, ‘lightGrey’, ‘ltSkyBlue’, ‘mediumTurquoise’, ‘dkGreen’, ‘darkSlateGrey’, ‘dkGray’, ‘dkSeaGreen’, ‘ltCyan’, ‘skyBlue’, ‘darkGreen’, ‘forestGreen’, ‘lightCyan’, ‘goldenrod’, ‘darkSlateGray’, ‘darkViolet’, ‘lightPink’, ‘lightSkyBlue’, ‘rosyBrown’, ‘fuchsia’, ‘ltGray’, ‘medVioletRed’, ‘blanchedAlmond’, ‘lightGreen’, ‘slateBlue’, ‘aliceBlue’, ‘darkBlue’, ‘dkRed’, ‘dkCyan’, ‘violet’, ‘snow’, ‘wheat’, ‘darkGray’, ‘royalBlue’, ‘greenYellow’, ‘darkRed’, ‘firebrick’, ‘aqua’, ‘medOrchid’, ‘coral’, ‘dkViolet’, ‘seaGreen’, ‘cornflowerBlue’, ‘ltGoldenrodYellow’, ‘medTurquoise’, ‘turquoise’, ‘paleGreen’, ‘dkOrchid’, ‘lemonChiffon’, ‘orange’, ‘paleTurquoise’, ‘mediumSlateBlue’, ‘papayaWhip’, ‘dkSlateGrey’, ‘blueViolet’, ‘mintCream’, ‘brown’, ‘lightSteelBlue’, ‘honeydew’, ‘darkGrey’, ‘ghostWhite’, ‘navy’, ‘floralWhite’, ‘bisque’, ‘darkMagenta’, ‘dimGray’, ‘ltCoral’, ‘oliveDrab’, ‘ivory’, ‘lime’, ‘slateGray’, ‘mistyRose’, ‘mediumPurple’, ‘mediumAquamarine’, ‘gold’, ‘steelBlue’, ‘grey’, ‘salmon’, ‘cornsilk’}
-
rad
¶ Values must be of type <class ‘float’>
-
schemeClr
¶ Value must be one of {‘accent2’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent6’, ‘dk1’, ‘dk2’, ‘phClr’, ‘hlink’, ‘lt2’, ‘lt1’, ‘bg2’, ‘accent4’, ‘folHlink’, ‘tx2’, ‘bg1’, ‘tx1’}
-
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.
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 {‘ltYellow’, ‘dkBlue’, ‘dkSlateGray’, ‘dkSalmon’, ‘silver’, ‘darkSlateBlue’, ‘maroon’, ‘orangeRed’, ‘lightCoral’, ‘burlyWood’, ‘darkOrange’, ‘mediumSpringGreen’, ‘teal’, ‘darkOliveGreen’, ‘beige’, ‘oldLace’, ‘khaki’, ‘limeGreen’, ‘whiteSmoke’, ‘darkGoldenrod’, ‘slateGrey’, ‘black’, ‘olive’, ‘lavender’, ‘tomato’, ‘darkCyan’, ‘lawnGreen’, ‘linen’, ‘darkKhaki’, ‘medSlateBlue’, ‘dkGoldenrod’, ‘seaShell’, ‘dkSlateBlue’, ‘tan’, ‘saddleBrown’, ‘paleGoldenrod’, ‘medSpringGreen’, ‘deepSkyBlue’, ‘dkGrey’, ‘medAquamarine’, ‘gray’, ‘navajoWhite’, ‘mediumSeaGreen’, ‘medBlue’, ‘lightBlue’, ‘magenta’, ‘ltGrey’, ‘indianRed’, ‘cadetBlue’, ‘dkOrange’, ‘deepPink’, ‘green’, ‘lightYellow’, ‘ltPink’, ‘dkMagenta’, ‘ltSalmon’, ‘darkOrchid’, ‘hotPink’, ‘azure’, ‘indigo’, ‘purple’, ‘sienna’, ‘ltSlateGrey’, ‘red’, ‘moccasin’, ‘dkTurquoise’, ‘ltSlateGray’, ‘antiqueWhite’, ‘blue’, ‘ltSteelBlue’, ‘powderBlue’, ‘gainsboro’, ‘white’, ‘thistle’, ‘midnightBlue’, ‘chartreuse’, ‘darkTurquoise’, ‘pink’, ‘peachPuff’, ‘lightSeaGreen’, ‘dkOliveGreen’, ‘lightGray’, ‘mediumBlue’, ‘peru’, ‘ltGreen’, ‘plum’, ‘sandyBrown’, ‘dkKhaki’, ‘cyan’, ‘yellow’, ‘mediumOrchid’, ‘lightSlateGray’, ‘paleVioletRed’, ‘lightSalmon’, ‘lightSlateGrey’, ‘medPurple’, ‘mediumVioletRed’, ‘darkSeaGreen’, ‘lavenderBlush’, ‘yellowGreen’, ‘ltBlue’, ‘dimGrey’, ‘dodgerBlue’, ‘lightGoldenrodYellow’, ‘springGreen’, ‘chocolate’, ‘orchid’, ‘aquamarine’, ‘darkSalmon’, ‘crimson’, ‘ltSeaGreen’, ‘medSeaGreen’, ‘lightGrey’, ‘ltSkyBlue’, ‘mediumTurquoise’, ‘dkGreen’, ‘darkSlateGrey’, ‘dkGray’, ‘dkSeaGreen’, ‘ltCyan’, ‘skyBlue’, ‘darkGreen’, ‘forestGreen’, ‘lightCyan’, ‘goldenrod’, ‘darkSlateGray’, ‘darkViolet’, ‘lightPink’, ‘lightSkyBlue’, ‘rosyBrown’, ‘fuchsia’, ‘ltGray’, ‘medVioletRed’, ‘blanchedAlmond’, ‘lightGreen’, ‘slateBlue’, ‘aliceBlue’, ‘darkBlue’, ‘dkRed’, ‘dkCyan’, ‘violet’, ‘snow’, ‘wheat’, ‘darkGray’, ‘royalBlue’, ‘greenYellow’, ‘darkRed’, ‘firebrick’, ‘aqua’, ‘medOrchid’, ‘coral’, ‘dkViolet’, ‘seaGreen’, ‘cornflowerBlue’, ‘ltGoldenrodYellow’, ‘medTurquoise’, ‘turquoise’, ‘paleGreen’, ‘dkOrchid’, ‘lemonChiffon’, ‘orange’, ‘paleTurquoise’, ‘mediumSlateBlue’, ‘papayaWhip’, ‘dkSlateGrey’, ‘blueViolet’, ‘mintCream’, ‘brown’, ‘lightSteelBlue’, ‘honeydew’, ‘darkGrey’, ‘ghostWhite’, ‘navy’, ‘floralWhite’, ‘bisque’, ‘darkMagenta’, ‘dimGray’, ‘ltCoral’, ‘oliveDrab’, ‘ivory’, ‘lime’, ‘slateGray’, ‘mistyRose’, ‘mediumPurple’, ‘mediumAquamarine’, ‘gold’, ‘steelBlue’, ‘grey’, ‘salmon’, ‘cornsilk’}
-
schemeClr
¶ Value must be one of {‘accent2’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent6’, ‘dk1’, ‘dk2’, ‘phClr’, ‘hlink’, ‘lt2’, ‘lt1’, ‘bg2’, ‘accent4’, ‘folHlink’, ‘tx2’, ‘bg1’, ‘tx1’}
-
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.
OuterShadowEffect
(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 {‘ctr’, ‘b’, ‘r’, ‘tr’, ‘l’, ‘bl’, ‘br’, ‘t’, ‘tl’}
-
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 {‘ltYellow’, ‘dkBlue’, ‘dkSlateGray’, ‘dkSalmon’, ‘silver’, ‘darkSlateBlue’, ‘maroon’, ‘orangeRed’, ‘lightCoral’, ‘burlyWood’, ‘darkOrange’, ‘mediumSpringGreen’, ‘teal’, ‘darkOliveGreen’, ‘beige’, ‘oldLace’, ‘khaki’, ‘limeGreen’, ‘whiteSmoke’, ‘darkGoldenrod’, ‘slateGrey’, ‘black’, ‘olive’, ‘lavender’, ‘tomato’, ‘darkCyan’, ‘lawnGreen’, ‘linen’, ‘darkKhaki’, ‘medSlateBlue’, ‘dkGoldenrod’, ‘seaShell’, ‘dkSlateBlue’, ‘tan’, ‘saddleBrown’, ‘paleGoldenrod’, ‘medSpringGreen’, ‘deepSkyBlue’, ‘dkGrey’, ‘medAquamarine’, ‘gray’, ‘navajoWhite’, ‘mediumSeaGreen’, ‘medBlue’, ‘lightBlue’, ‘magenta’, ‘ltGrey’, ‘indianRed’, ‘cadetBlue’, ‘dkOrange’, ‘deepPink’, ‘green’, ‘lightYellow’, ‘ltPink’, ‘dkMagenta’, ‘ltSalmon’, ‘darkOrchid’, ‘hotPink’, ‘azure’, ‘indigo’, ‘purple’, ‘sienna’, ‘ltSlateGrey’, ‘red’, ‘moccasin’, ‘dkTurquoise’, ‘ltSlateGray’, ‘antiqueWhite’, ‘blue’, ‘ltSteelBlue’, ‘powderBlue’, ‘gainsboro’, ‘white’, ‘thistle’, ‘midnightBlue’, ‘chartreuse’, ‘darkTurquoise’, ‘pink’, ‘peachPuff’, ‘lightSeaGreen’, ‘dkOliveGreen’, ‘lightGray’, ‘mediumBlue’, ‘peru’, ‘ltGreen’, ‘plum’, ‘sandyBrown’, ‘dkKhaki’, ‘cyan’, ‘yellow’, ‘mediumOrchid’, ‘lightSlateGray’, ‘paleVioletRed’, ‘lightSalmon’, ‘lightSlateGrey’, ‘medPurple’, ‘mediumVioletRed’, ‘darkSeaGreen’, ‘lavenderBlush’, ‘yellowGreen’, ‘ltBlue’, ‘dimGrey’, ‘dodgerBlue’, ‘lightGoldenrodYellow’, ‘springGreen’, ‘chocolate’, ‘orchid’, ‘aquamarine’, ‘darkSalmon’, ‘crimson’, ‘ltSeaGreen’, ‘medSeaGreen’, ‘lightGrey’, ‘ltSkyBlue’, ‘mediumTurquoise’, ‘dkGreen’, ‘darkSlateGrey’, ‘dkGray’, ‘dkSeaGreen’, ‘ltCyan’, ‘skyBlue’, ‘darkGreen’, ‘forestGreen’, ‘lightCyan’, ‘goldenrod’, ‘darkSlateGray’, ‘darkViolet’, ‘lightPink’, ‘lightSkyBlue’, ‘rosyBrown’, ‘fuchsia’, ‘ltGray’, ‘medVioletRed’, ‘blanchedAlmond’, ‘lightGreen’, ‘slateBlue’, ‘aliceBlue’, ‘darkBlue’, ‘dkRed’, ‘dkCyan’, ‘violet’, ‘snow’, ‘wheat’, ‘darkGray’, ‘royalBlue’, ‘greenYellow’, ‘darkRed’, ‘firebrick’, ‘aqua’, ‘medOrchid’, ‘coral’, ‘dkViolet’, ‘seaGreen’, ‘cornflowerBlue’, ‘ltGoldenrodYellow’, ‘medTurquoise’, ‘turquoise’, ‘paleGreen’, ‘dkOrchid’, ‘lemonChiffon’, ‘orange’, ‘paleTurquoise’, ‘mediumSlateBlue’, ‘papayaWhip’, ‘dkSlateGrey’, ‘blueViolet’, ‘mintCream’, ‘brown’, ‘lightSteelBlue’, ‘honeydew’, ‘darkGrey’, ‘ghostWhite’, ‘navy’, ‘floralWhite’, ‘bisque’, ‘darkMagenta’, ‘dimGray’, ‘ltCoral’, ‘oliveDrab’, ‘ivory’, ‘lime’, ‘slateGray’, ‘mistyRose’, ‘mediumPurple’, ‘mediumAquamarine’, ‘gold’, ‘steelBlue’, ‘grey’, ‘salmon’, ‘cornsilk’}
-
rotWithShape
¶ Values must be of type <class ‘bool’>
-
schemeClr
¶ Value must be one of {‘accent2’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent6’, ‘dk1’, ‘dk2’, ‘phClr’, ‘hlink’, ‘lt2’, ‘lt1’, ‘bg2’, ‘accent4’, ‘folHlink’, ‘tx2’, ‘bg1’, ‘tx1’}
-
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’>
-
-
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 {‘shdw6’, ‘shdw13’, ‘shdw12’, ‘shdw2’, ‘shdw9’, ‘shdw14’, ‘shdw11’, ‘shdw18’, ‘shdw19’, ‘shdw7’, ‘shdw4’, ‘shdw15’, ‘shdw5’, ‘shdw17’, ‘shdw20’, ‘shdw3’, ‘shdw10’, ‘shdw8’, ‘shdw1’, ‘shdw16’}
-
prstClr
¶ Value must be one of {‘ltYellow’, ‘dkBlue’, ‘dkSlateGray’, ‘dkSalmon’, ‘silver’, ‘darkSlateBlue’, ‘maroon’, ‘orangeRed’, ‘lightCoral’, ‘burlyWood’, ‘darkOrange’, ‘mediumSpringGreen’, ‘teal’, ‘darkOliveGreen’, ‘beige’, ‘oldLace’, ‘khaki’, ‘limeGreen’, ‘whiteSmoke’, ‘darkGoldenrod’, ‘slateGrey’, ‘black’, ‘olive’, ‘lavender’, ‘tomato’, ‘darkCyan’, ‘lawnGreen’, ‘linen’, ‘darkKhaki’, ‘medSlateBlue’, ‘dkGoldenrod’, ‘seaShell’, ‘dkSlateBlue’, ‘tan’, ‘saddleBrown’, ‘paleGoldenrod’, ‘medSpringGreen’, ‘deepSkyBlue’, ‘dkGrey’, ‘medAquamarine’, ‘gray’, ‘navajoWhite’, ‘mediumSeaGreen’, ‘medBlue’, ‘lightBlue’, ‘magenta’, ‘ltGrey’, ‘indianRed’, ‘cadetBlue’, ‘dkOrange’, ‘deepPink’, ‘green’, ‘lightYellow’, ‘ltPink’, ‘dkMagenta’, ‘ltSalmon’, ‘darkOrchid’, ‘hotPink’, ‘azure’, ‘indigo’, ‘purple’, ‘sienna’, ‘ltSlateGrey’, ‘red’, ‘moccasin’, ‘dkTurquoise’, ‘ltSlateGray’, ‘antiqueWhite’, ‘blue’, ‘ltSteelBlue’, ‘powderBlue’, ‘gainsboro’, ‘white’, ‘thistle’, ‘midnightBlue’, ‘chartreuse’, ‘darkTurquoise’, ‘pink’, ‘peachPuff’, ‘lightSeaGreen’, ‘dkOliveGreen’, ‘lightGray’, ‘mediumBlue’, ‘peru’, ‘ltGreen’, ‘plum’, ‘sandyBrown’, ‘dkKhaki’, ‘cyan’, ‘yellow’, ‘mediumOrchid’, ‘lightSlateGray’, ‘paleVioletRed’, ‘lightSalmon’, ‘lightSlateGrey’, ‘medPurple’, ‘mediumVioletRed’, ‘darkSeaGreen’, ‘lavenderBlush’, ‘yellowGreen’, ‘ltBlue’, ‘dimGrey’, ‘dodgerBlue’, ‘lightGoldenrodYellow’, ‘springGreen’, ‘chocolate’, ‘orchid’, ‘aquamarine’, ‘darkSalmon’, ‘crimson’, ‘ltSeaGreen’, ‘medSeaGreen’, ‘lightGrey’, ‘ltSkyBlue’, ‘mediumTurquoise’, ‘dkGreen’, ‘darkSlateGrey’, ‘dkGray’, ‘dkSeaGreen’, ‘ltCyan’, ‘skyBlue’, ‘darkGreen’, ‘forestGreen’, ‘lightCyan’, ‘goldenrod’, ‘darkSlateGray’, ‘darkViolet’, ‘lightPink’, ‘lightSkyBlue’, ‘rosyBrown’, ‘fuchsia’, ‘ltGray’, ‘medVioletRed’, ‘blanchedAlmond’, ‘lightGreen’, ‘slateBlue’, ‘aliceBlue’, ‘darkBlue’, ‘dkRed’, ‘dkCyan’, ‘violet’, ‘snow’, ‘wheat’, ‘darkGray’, ‘royalBlue’, ‘greenYellow’, ‘darkRed’, ‘firebrick’, ‘aqua’, ‘medOrchid’, ‘coral’, ‘dkViolet’, ‘seaGreen’, ‘cornflowerBlue’, ‘ltGoldenrodYellow’, ‘medTurquoise’, ‘turquoise’, ‘paleGreen’, ‘dkOrchid’, ‘lemonChiffon’, ‘orange’, ‘paleTurquoise’, ‘mediumSlateBlue’, ‘papayaWhip’, ‘dkSlateGrey’, ‘blueViolet’, ‘mintCream’, ‘brown’, ‘lightSteelBlue’, ‘honeydew’, ‘darkGrey’, ‘ghostWhite’, ‘navy’, ‘floralWhite’, ‘bisque’, ‘darkMagenta’, ‘dimGray’, ‘ltCoral’, ‘oliveDrab’, ‘ivory’, ‘lime’, ‘slateGray’, ‘mistyRose’, ‘mediumPurple’, ‘mediumAquamarine’, ‘gold’, ‘steelBlue’, ‘grey’, ‘salmon’, ‘cornsilk’}
-
schemeClr
¶ Value must be one of {‘accent2’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent6’, ‘dk1’, ‘dk2’, ‘phClr’, ‘hlink’, ‘lt2’, ‘lt1’, ‘bg2’, ‘accent4’, ‘folHlink’, ‘tx2’, ‘bg1’, ‘tx1’}
-
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 {‘ctr’, ‘b’, ‘r’, ‘tr’, ‘l’, ‘bl’, ‘br’, ‘t’, ‘tl’}
-
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’>
-