openpyxl.drawing.colors module

class openpyxl.drawing.colors.ColorChoice(scrgbClr=None, srgbClr=None, hslClr=None, sysClr=None, schemeClr=None, prstClr=None)

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 {‘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’>

tagname = 'colorChoice'

class openpyxl.drawing.colors.ColorChoiceDescriptor(*args, **kw)

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)

Bases: openpyxl.descriptors.serialisable.Serialisable

accent1

Value must be one of {‘accent2’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent6’, ‘dk1’, ‘lt2’, ‘hlink’, ‘lt1’, ‘accent4’, ‘folHlink’, ‘dk2’}

accent2

Value must be one of {‘accent2’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent6’, ‘dk1’, ‘lt2’, ‘hlink’, ‘lt1’, ‘accent4’, ‘folHlink’, ‘dk2’}

accent3

Value must be one of {‘accent2’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent6’, ‘dk1’, ‘lt2’, ‘hlink’, ‘lt1’, ‘accent4’, ‘folHlink’, ‘dk2’}

accent4

Value must be one of {‘accent2’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent6’, ‘dk1’, ‘lt2’, ‘hlink’, ‘lt1’, ‘accent4’, ‘folHlink’, ‘dk2’}

accent5

Value must be one of {‘accent2’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent6’, ‘dk1’, ‘lt2’, ‘hlink’, ‘lt1’, ‘accent4’, ‘folHlink’, ‘dk2’}

accent6

Value must be one of {‘accent2’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent6’, ‘dk1’, ‘lt2’, ‘hlink’, ‘lt1’, ‘accent4’, ‘folHlink’, ‘dk2’}

bg1

Value must be one of {‘accent2’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent6’, ‘dk1’, ‘lt2’, ‘hlink’, ‘lt1’, ‘accent4’, ‘folHlink’, ‘dk2’}

bg2

Value must be one of {‘accent2’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent6’, ‘dk1’, ‘lt2’, ‘hlink’, ‘lt1’, ‘accent4’, ‘folHlink’, ‘dk2’}

extLst

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

folHlink

Value must be one of {‘accent2’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent6’, ‘dk1’, ‘lt2’, ‘hlink’, ‘lt1’, ‘accent4’, ‘folHlink’, ‘dk2’}

hlink

Value must be one of {‘accent2’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent6’, ‘dk1’, ‘lt2’, ‘hlink’, ‘lt1’, ‘accent4’, ‘folHlink’, ‘dk2’}

tagname = 'clrMapOvr'

tx1

Value must be one of {‘accent2’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent6’, ‘dk1’, ‘lt2’, ‘hlink’, ‘lt1’, ‘accent4’, ‘folHlink’, ‘dk2’}

tx2

Value must be one of {‘accent2’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent6’, ‘dk1’, ‘lt2’, ‘hlink’, ‘lt1’, ‘accent4’, ‘folHlink’, ‘dk2’}

class openpyxl.drawing.colors.HSLColor(hue=None, sat=None, lum=None)

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)

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.SystemColor(val='bg1', 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)

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 ‘openpyxl.styles.colors.RGB’>

lum

Values must be of type <class ‘int’>

lumMod

Values must be of type <class ‘int’>

lumOff

Values must be of type <class ‘int’>

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 {‘accent2’, ‘accent5’, ‘accent1’, ‘accent3’, ‘accent6’, ‘dk1’, ‘dk2’, ‘phClr’, ‘hlink’, ‘lt2’, ‘lt1’, ‘bg2’, ‘accent4’, ‘folHlink’, ‘tx2’, ‘bg1’, ‘tx1’}

class openpyxl.drawing.colors.Transform

Bases: openpyxl.descriptors.serialisable.Serialisable