openpyxl.drawing.colors module¶
-
class
openpyxl.drawing.colors.
ColorChoice
(scrgbClr=None, srgbClr=None, hslClr=None, sysClr=None, schemeClr=None, prstClr=None)[source]¶ Bases:
openpyxl.descriptors.serialisable.Serialisable
-
RGB
¶ 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”)
-
RGBPercent
¶ 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”)
-
hslClr
¶ Values must be of type <class ‘openpyxl.drawing.colors.HSLColor’>
-
namespace
= 'http://schemas.openxmlformats.org/drawingml/2006/main'¶
-
prstClr
¶ Value must be one of {‘beige’, ‘lightBlue’, ‘sienna’, ‘oldLace’, ‘dkKhaki’, ‘floralWhite’, ‘medTurquoise’, ‘ltGrey’, ‘dkOrchid’, ‘dkGoldenrod’, ‘deepSkyBlue’, ‘olive’, ‘bisque’, ‘crimson’, ‘springGreen’, ‘dkGrey’, ‘darkOrchid’, ‘darkSalmon’, ‘slateBlue’, ‘goldenrod’, ‘lightSkyBlue’, ‘lightGrey’, ‘darkGreen’, ‘aliceBlue’, ‘lavenderBlush’, ‘lemonChiffon’, ‘mediumOrchid’, ‘salmon’, ‘medSlateBlue’, ‘cornsilk’, ‘burlyWood’, ‘yellowGreen’, ‘dkOliveGreen’, ‘darkSeaGreen’, ‘ltGray’, ‘dkSeaGreen’, ‘navajoWhite’, ‘darkSlateBlue’, ‘forestGreen’, ‘darkKhaki’, ‘maroon’, ‘saddleBrown’, ‘ltSlateGray’, ‘darkBlue’, ‘paleGreen’, ‘hotPink’, ‘paleTurquoise’, ‘medSeaGreen’, ‘orchid’, ‘mediumSeaGreen’, ‘rosyBrown’, ‘dkGray’, ‘tomato’, ‘blanchedAlmond’, ‘mediumTurquoise’, ‘sandyBrown’, ‘lightCyan’, ‘cyan’, ‘ltBlue’, ‘darkOrange’, ‘dkTurquoise’, ‘ltCyan’, ‘slateGrey’, ‘lime’, ‘plum’, ‘coral’, ‘dkSlateGrey’, ‘ltCoral’, ‘dodgerBlue’, ‘darkSlateGray’, ‘ltGoldenrodYellow’, ‘mistyRose’, ‘lightGreen’, ‘ltSeaGreen’, ‘green’, ‘navy’, ‘steelBlue’, ‘medSpringGreen’, ‘grey’, ‘orange’, ‘honeydew’, ‘gray’, ‘gainsboro’, ‘lightSteelBlue’, ‘ltPink’, ‘dimGrey’, ‘greenYellow’, ‘mediumSpringGreen’, ‘skyBlue’, ‘azure’, ‘dkViolet’, ‘medPurple’, ‘lightYellow’, ‘gold’, ‘brown’, ‘lavender’, ‘mediumSlateBlue’, ‘royalBlue’, ‘dkSalmon’, ‘seaGreen’, ‘peru’, ‘dkSlateBlue’, ‘darkViolet’, ‘lightSalmon’, ‘medBlue’, ‘darkGray’, ‘darkTurquoise’, ‘cornflowerBlue’, ‘mediumAquamarine’, ‘paleVioletRed’, ‘thistle’, ‘dkOrange’, ‘cadetBlue’, ‘slateGray’, ‘mintCream’, ‘darkMagenta’, ‘lightGray’, ‘violet’, ‘ltYellow’, ‘paleGoldenrod’, ‘ltSalmon’, ‘ltSkyBlue’, ‘powderBlue’, ‘lawnGreen’, ‘medAquamarine’, ‘lightGoldenrodYellow’, ‘dimGray’, ‘mediumBlue’, ‘mediumVioletRed’, ‘dkCyan’, ‘blueViolet’, ‘ltGreen’, ‘antiqueWhite’, ‘blue’, ‘wheat’, ‘orangeRed’, ‘deepPink’, ‘black’, ‘magenta’, ‘tan’, ‘lightCoral’, ‘aqua’, ‘silver’, ‘darkGoldenrod’, ‘pink’, ‘papayaWhip’, ‘peachPuff’, ‘ghostWhite’, ‘aquamarine’, ‘ivory’, ‘chocolate’, ‘midnightBlue’, ‘indigo’, ‘linen’, ‘indianRed’, ‘moccasin’, ‘whiteSmoke’, ‘teal’, ‘lightSlateGrey’, ‘darkSlateGrey’, ‘seaShell’, ‘dkMagenta’, ‘fuchsia’, ‘darkOliveGreen’, ‘chartreuse’, ‘firebrick’, ‘darkGrey’, ‘oliveDrab’, ‘lightSeaGreen’, ‘purple’, ‘dkSlateGray’, ‘dkBlue’, ‘darkCyan’, ‘turquoise’, ‘limeGreen’, ‘white’, ‘ltSlateGrey’, ‘medVioletRed’, ‘dkGreen’, ‘dkRed’, ‘lightPink’, ‘medOrchid’, ‘red’, ‘snow’, ‘lightSlateGray’, ‘darkRed’, ‘mediumPurple’, ‘khaki’, ‘ltSteelBlue’, ‘yellow’}
-
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’>
-
tagname
= 'colorChoice'¶
-
-
class
openpyxl.drawing.colors.
ColorChoiceDescriptor
(*args, **kw)[source]¶ Bases:
openpyxl.descriptors.base.Typed
Objects can choose from 7 different kinds of color system. Assume RGBHex if a string is passed in.
-
allow_none
= True¶
-
expected_type
¶ alias of
ColorChoice
-
-
class
openpyxl.drawing.colors.
ColorMapping
(bg1='lt1', tx1='dk1', bg2='lt2', tx2='dk2', accent1='accent1', accent2='accent2', accent3='accent3', accent4='accent4', accent5='accent5', accent6='accent6', hlink='hlink', folHlink='folHlink', extLst=None)[source]¶ Bases:
openpyxl.descriptors.serialisable.Serialisable
-
accent1
¶ Value must be one of {‘accent6’, ‘hlink’, ‘dk2’, ‘lt1’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent4’, ‘dk1’, ‘accent2’, ‘lt2’, ‘folHlink’}
-
accent2
¶ Value must be one of {‘accent6’, ‘hlink’, ‘dk2’, ‘lt1’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent4’, ‘dk1’, ‘accent2’, ‘lt2’, ‘folHlink’}
-
accent3
¶ Value must be one of {‘accent6’, ‘hlink’, ‘dk2’, ‘lt1’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent4’, ‘dk1’, ‘accent2’, ‘lt2’, ‘folHlink’}
-
accent4
¶ Value must be one of {‘accent6’, ‘hlink’, ‘dk2’, ‘lt1’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent4’, ‘dk1’, ‘accent2’, ‘lt2’, ‘folHlink’}
-
accent5
¶ Value must be one of {‘accent6’, ‘hlink’, ‘dk2’, ‘lt1’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent4’, ‘dk1’, ‘accent2’, ‘lt2’, ‘folHlink’}
-
accent6
¶ Value must be one of {‘accent6’, ‘hlink’, ‘dk2’, ‘lt1’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent4’, ‘dk1’, ‘accent2’, ‘lt2’, ‘folHlink’}
-
bg1
¶ Value must be one of {‘accent6’, ‘hlink’, ‘dk2’, ‘lt1’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent4’, ‘dk1’, ‘accent2’, ‘lt2’, ‘folHlink’}
-
bg2
¶ Value must be one of {‘accent6’, ‘hlink’, ‘dk2’, ‘lt1’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent4’, ‘dk1’, ‘accent2’, ‘lt2’, ‘folHlink’}
-
extLst
¶ Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>
-
folHlink
¶ Value must be one of {‘accent6’, ‘hlink’, ‘dk2’, ‘lt1’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent4’, ‘dk1’, ‘accent2’, ‘lt2’, ‘folHlink’}
-
hlink
¶ Value must be one of {‘accent6’, ‘hlink’, ‘dk2’, ‘lt1’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent4’, ‘dk1’, ‘accent2’, ‘lt2’, ‘folHlink’}
-
tagname
= 'clrMapOvr'¶
-
tx1
¶ Value must be one of {‘accent6’, ‘hlink’, ‘dk2’, ‘lt1’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent4’, ‘dk1’, ‘accent2’, ‘lt2’, ‘folHlink’}
-
tx2
¶ Value must be one of {‘accent6’, ‘hlink’, ‘dk2’, ‘lt1’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent4’, ‘dk1’, ‘accent2’, ‘lt2’, ‘folHlink’}
-
-
class
openpyxl.drawing.colors.
HSLColor
(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 ‘float’>
-
sat
¶ Values must be of type <class ‘float’>
-
tagname
= 'hslClr'¶
-
-
class
openpyxl.drawing.colors.
RGBPercent
(r=None, g=None, b=None)[source]¶ Bases:
openpyxl.descriptors.serialisable.Serialisable
-
b
¶ Values must be of type <class ‘float’>
-
g
¶ Values must be of type <class ‘float’>
-
r
¶ Values must be of type <class ‘float’>
-
tagname
= 'rgbClr'¶
-
-
class
openpyxl.drawing.colors.
SchemeColor
(tint=None, shade=None, comp=None, inv=None, gray=None, alpha=None, alphaOff=None, alphaMod=None, hue=None, hueOff=None, hueMod=None, sat=None, satOff=None, satMod=None, lum=None, lumOff=None, lumMod=None, red=None, redOff=None, redMod=None, green=None, greenOff=None, greenMod=None, blue=None, blueOff=None, blueMod=None, gamma=None, invGamma=None, val=None)[source]¶ Bases:
openpyxl.descriptors.serialisable.Serialisable
-
alpha
¶ Values must be of type <class ‘int’>
-
alphaMod
¶ Values must be of type <class ‘int’>
-
alphaOff
¶ Values must be of type <class ‘int’>
-
blue
¶ Values must be of type <class ‘int’>
-
blueMod
¶ Values must be of type <class ‘int’>
-
blueOff
¶ Values must be of type <class ‘int’>
-
comp
¶ Values must be of type <class ‘bool’>
-
gamma
¶ Values must be of type <class ‘bool’>
-
gray
¶ Values must be of type <class ‘int’>
-
green
¶ Values must be of type <class ‘int’>
-
greenMod
¶ Values must be of type <class ‘int’>
-
greenOff
¶ Values must be of type <class ‘int’>
-
hue
¶ Values must be of type <class ‘int’>
-
hueMod
¶ Values must be of type <class ‘int’>
-
hueOff
¶ Values must be of type <class ‘int’>
-
inv
¶ Values must be of type <class ‘int’>
-
invGamma
¶ Values must be of type <class ‘bool’>
-
lum
¶ Values must be of type <class ‘int’>
-
lumMod
¶ Values must be of type <class ‘int’>
-
lumOff
¶ Values must be of type <class ‘int’>
-
namespace
= 'http://schemas.openxmlformats.org/drawingml/2006/main'¶
-
red
¶ Values must be of type <class ‘int’>
-
redMod
¶ Values must be of type <class ‘int’>
-
redOff
¶ Values must be of type <class ‘int’>
-
sat
¶ Values must be of type <class ‘int’>
-
satMod
¶ Values must be of type <class ‘int’>
-
satOff
¶ Values must be of type <class ‘int’>
-
shade
¶ Values must be of type <class ‘int’>
-
tagname
= 'schemeClr'¶
-
tint
¶ Values must be of type <class ‘int’>
-
val
¶ Value must be one of {‘accent6’, ‘bg2’, ‘hlink’, ‘tx1’, ‘phClr’, ‘lt1’, ‘bg1’, ‘tx2’, ‘accent5’, ‘dk2’, ‘accent1’, ‘accent3’, ‘accent4’, ‘dk1’, ‘accent2’, ‘lt2’, ‘folHlink’}
-
-
class
openpyxl.drawing.colors.
SystemColor
(val='windowText', lastClr=None, tint=None, shade=None, comp=None, inv=None, gray=None, alpha=None, alphaOff=None, alphaMod=None, hue=None, hueOff=None, hueMod=None, sat=None, satOff=None, satMod=None, lum=None, lumOff=None, lumMod=None, red=None, redOff=None, redMod=None, green=None, greenOff=None, greenMod=None, blue=None, blueOff=None, blueMod=None, gamma=None, invGamma=None)[source]¶ Bases:
openpyxl.descriptors.serialisable.Serialisable
-
alpha
¶ Values must be of type <class ‘int’>
-
alphaMod
¶ Values must be of type <class ‘int’>
-
alphaOff
¶ Values must be of type <class ‘int’>
-
blue
¶ Values must be of type <class ‘int’>
-
blueMod
¶ Values must be of type <class ‘int’>
-
blueOff
¶ Values must be of type <class ‘int’>
-
comp
¶ Values must be of type <class ‘openpyxl.drawing.colors.Transform’>
-
gamma
¶ Values must be of type <class ‘openpyxl.drawing.colors.Transform’>
-
gray
¶ Values must be of type <class ‘openpyxl.drawing.colors.Transform’>
-
green
¶ Values must be of type <class ‘int’>
-
greenMod
¶ Values must be of type <class ‘int’>
-
greenOff
¶ Values must be of type <class ‘int’>
-
hue
¶ Values must be of type <class ‘int’>
-
hueMod
¶ Values must be of type <class ‘int’>
-
hueOff
¶ Values must be of type <class ‘int’>
-
inv
¶ Values must be of type <class ‘openpyxl.drawing.colors.Transform’>
-
invGamma
¶ Values must be of type <class ‘openpyxl.drawing.colors.Transform’>
-
lastClr
¶ Values must be of type <class ‘str’>
-
lum
¶ Values must be of type <class ‘int’>
-
lumMod
¶ Values must be of type <class ‘int’>
-
lumOff
¶ Values must be of type <class ‘int’>
-
namespace
= 'http://schemas.openxmlformats.org/drawingml/2006/main'¶
-
red
¶ Values must be of type <class ‘int’>
-
redMod
¶ Values must be of type <class ‘int’>
-
redOff
¶ Values must be of type <class ‘int’>
-
sat
¶ Values must be of type <class ‘int’>
-
satMod
¶ Values must be of type <class ‘int’>
-
satOff
¶ Values must be of type <class ‘int’>
-
shade
¶ Values must be of type <class ‘int’>
-
tagname
= 'sysClr'¶
-
tint
¶ Values must be of type <class ‘int’>
-
val
¶ Value must be one of {‘menuText’, ‘3dLight’, ‘btnHighlight’, ‘hotLight’, ‘highlight’, ‘infoText’, ‘activeCaption’, ‘highlightText’, ‘appWorkspace’, ‘btnFace’, ‘btnText’, ‘grayText’, ‘activeBorder’, ‘menu’, ‘windowFrame’, ‘inactiveCaption’, ‘3dDkShadow’, ‘gradientInactiveCaption’, ‘gradientActiveCaption’, ‘inactiveCaptionText’, ‘infoBk’, ‘inactiveBorder’, ‘menuHighlight’, ‘menuBar’, ‘windowText’, ‘window’, ‘captionText’, ‘btnShadow’, ‘scrollBar’, ‘background’}
-