openpyxl.drawing.colors.
ColorChoice
(
scrgbClr=None
,
srgbClr=None
,
hslClr=None
,
sysClr=None
,
schemeClr=None
,
prstClr=None
)
[source]
¶
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 {‘cornflowerBlue’, ‘darkCyan’, ‘darkSlateGrey’, ‘darkSlateBlue’, ‘navajoWhite’, ‘lightSteelBlue’, ‘white’, ‘lawnGreen’, ‘mediumVioletRed’, ‘wheat’, ‘snow’, ‘yellow’, ‘dkOrange’, ‘ivory’, ‘beige’, ‘mediumOrchid’, ‘seaShell’, ‘medSlateBlue’, ‘lavender’, ‘fuchsia’, ‘limeGreen’, ‘aqua’, ‘brown’, ‘black’, ‘cornsilk’, ‘springGreen’, ‘dkGreen’, ‘thistle’, ‘gainsboro’, ‘medOrchid’, ‘magenta’, ‘orchid’, ‘dimGray’, ‘burlyWood’, ‘coral’, ‘darkOliveGreen’, ‘navy’, ‘dkOliveGreen’, ‘gray’, ‘ltYellow’, ‘aliceBlue’, ‘dkBlue’, ‘goldenrod’, ‘ltCoral’, ‘firebrick’, ‘steelBlue’, ‘tomato’, ‘grey’, ‘hotPink’, ‘dkGrey’, ‘lightGray’, ‘lightSlateGray’, ‘oldLace’, ‘lightGreen’, ‘red’, ‘lemonChiffon’, ‘teal’, ‘medVioletRed’, ‘greenYellow’, ‘mediumSlateBlue’, ‘dkSlateGray’, ‘moccasin’, ‘pink’, ‘slateGray’, ‘saddleBrown’, ‘chocolate’, ‘lightCoral’, ‘orangeRed’, ‘sienna’, ‘lightBlue’, ‘olive’, ‘tan’, ‘lime’, ‘medSeaGreen’, ‘paleGoldenrod’, ‘darkBlue’, ‘ltPink’, ‘peru’, ‘lightCyan’, ‘blue’, ‘darkGray’, ‘mediumSeaGreen’, ‘dkSalmon’, ‘purple’, ‘dkCyan’, ‘dkOrchid’, ‘salmon’, ‘darkMagenta’, ‘lightSalmon’, ‘ltGrey’, ‘aquamarine’, ‘medTurquoise’, ‘cadetBlue’, ‘maroon’, ‘azure’, ‘mediumSpringGreen’, ‘mintCream’, ‘darkSeaGreen’, ‘darkGrey’, ‘lightSkyBlue’, ‘paleTurquoise’, ‘ltCyan’, ‘ltSeaGreen’, ‘dkSlateBlue’, ‘dkMagenta’, ‘darkGoldenrod’, ‘peachPuff’, ‘mediumTurquoise’, ‘lightSeaGreen’, ‘lightPink’, ‘ltSkyBlue’, ‘darkSalmon’, ‘medAquamarine’, ‘slateGrey’, ‘floralWhite’, ‘ltSteelBlue’, ‘crimson’, ‘darkOrchid’, ‘ltGray’, ‘cyan’, ‘darkTurquoise’, ‘gold’, ‘papayaWhip’, ‘lightGrey’, ‘paleGreen’, ‘indianRed’, ‘lightSlateGrey’, ‘blanchedAlmond’, ‘powderBlue’, ‘ltGreen’, ‘dodgerBlue’, ‘mediumAquamarine’, ‘royalBlue’, ‘ltSalmon’, ‘medBlue’, ‘dkGoldenrod’, ‘dkRed’, ‘midnightBlue’, ‘green’, ‘indigo’, ‘lightGoldenrodYellow’, ‘plum’, ‘darkOrange’, ‘rosyBrown’, ‘ltGoldenrodYellow’, ‘darkRed’, ‘bisque’, ‘antiqueWhite’, ‘oliveDrab’, ‘mistyRose’, ‘slateBlue’, ‘dkSeaGreen’, ‘darkSlateGray’, ‘blueViolet’, ‘deepPink’, ‘violet’, ‘mediumBlue’, ‘medPurple’, ‘dimGrey’, ‘lavenderBlush’, ‘ltBlue’, ‘deepSkyBlue’, ‘ltSlateGray’, ‘linen’, ‘chartreuse’, ‘darkKhaki’, ‘dkGray’, ‘ltSlateGrey’, ‘mediumPurple’, ‘medSpringGreen’, ‘turquoise’, ‘khaki’, ‘yellowGreen’, ‘skyBlue’, ‘silver’, ‘darkViolet’, ‘dkSlateGrey’, ‘seaGreen’, ‘dkKhaki’, ‘forestGreen’, ‘ghostWhite’, ‘paleVioletRed’, ‘darkGreen’, ‘honeydew’, ‘whiteSmoke’, ‘orange’, ‘sandyBrown’, ‘dkTurquoise’, ‘dkViolet’, ‘lightYellow’}
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'
¶
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
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]
¶
accent1
¶
Value must be one of {‘lt1’, ‘dk2’, ‘accent2’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent4’, ‘hlink’, ‘folHlink’, ‘lt2’, ‘accent6’, ‘dk1’}
accent2
¶
Value must be one of {‘lt1’, ‘dk2’, ‘accent2’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent4’, ‘hlink’, ‘folHlink’, ‘lt2’, ‘accent6’, ‘dk1’}
accent3
¶
Value must be one of {‘lt1’, ‘dk2’, ‘accent2’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent4’, ‘hlink’, ‘folHlink’, ‘lt2’, ‘accent6’, ‘dk1’}
accent4
¶
Value must be one of {‘lt1’, ‘dk2’, ‘accent2’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent4’, ‘hlink’, ‘folHlink’, ‘lt2’, ‘accent6’, ‘dk1’}
accent5
¶
Value must be one of {‘lt1’, ‘dk2’, ‘accent2’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent4’, ‘hlink’, ‘folHlink’, ‘lt2’, ‘accent6’, ‘dk1’}
accent6
¶
Value must be one of {‘lt1’, ‘dk2’, ‘accent2’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent4’, ‘hlink’, ‘folHlink’, ‘lt2’, ‘accent6’, ‘dk1’}
bg1
¶
Value must be one of {‘lt1’, ‘dk2’, ‘accent2’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent4’, ‘hlink’, ‘folHlink’, ‘lt2’, ‘accent6’, ‘dk1’}
bg2
¶
Value must be one of {‘lt1’, ‘dk2’, ‘accent2’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent4’, ‘hlink’, ‘folHlink’, ‘lt2’, ‘accent6’, ‘dk1’}
extLst
¶
Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>
folHlink
¶
Value must be one of {‘lt1’, ‘dk2’, ‘accent2’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent4’, ‘hlink’, ‘folHlink’, ‘lt2’, ‘accent6’, ‘dk1’}
hlink
¶
Value must be one of {‘lt1’, ‘dk2’, ‘accent2’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent4’, ‘hlink’, ‘folHlink’, ‘lt2’, ‘accent6’, ‘dk1’}
tagname
= 'clrMapOvr'
¶
tx1
¶
Value must be one of {‘lt1’, ‘dk2’, ‘accent2’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent4’, ‘hlink’, ‘folHlink’, ‘lt2’, ‘accent6’, ‘dk1’}
tx2
¶
Value must be one of {‘lt1’, ‘dk2’, ‘accent2’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent4’, ‘hlink’, ‘folHlink’, ‘lt2’, ‘accent6’, ‘dk1’}
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'
¶
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'
¶
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]
¶
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 {‘accent2’, ‘accent5’, ‘lt1’, ‘dk2’, ‘bg2’, ‘tx1’, ‘accent1’, ‘dk1’, ‘accent4’, ‘hlink’, ‘folHlink’, ‘lt2’, ‘accent6’, ‘accent3’, ‘bg1’, ‘phClr’, ‘tx2’}
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]
¶
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 {‘highlight’, ‘activeCaption’, ‘gradientActiveCaption’, ‘menuText’, ‘activeBorder’, ‘captionText’, ‘btnShadow’, ‘3dLight’, ‘windowFrame’, ‘hotLight’, ‘infoText’, ‘menu’, ‘menuHighlight’, ‘menuBar’, ‘background’, ‘windowText’, ‘highlightText’, ‘btnText’, ‘inactiveCaption’, ‘infoBk’, ‘3dDkShadow’, ‘inactiveCaptionText’, ‘scrollBar’, ‘gradientInactiveCaption’, ‘grayText’, ‘btnHighlight’, ‘window’, ‘inactiveBorder’, ‘btnFace’, ‘appWorkspace’}