openpyxl.drawing.fill.
Blip
(
cstate=None
,
embed=None
,
link=None
,
noGrp=None
,
noSelect=None
,
noRot=None
,
noChangeAspect=None
,
noMove=None
,
noResize=None
,
noEditPoints=None
,
noAdjustHandles=None
,
noChangeArrowheads=None
,
noChangeShapeType=None
,
extLst=None
,
alphaBiLevel=None
,
alphaCeiling=None
,
alphaFloor=None
,
alphaInv=None
,
alphaMod=None
,
alphaModFix=None
,
alphaRepl=None
,
biLevel=None
,
blur=None
,
clrChange=None
,
clrRepl=None
,
duotone=None
,
fillOverlay=None
,
grayscl=None
,
hsl=None
,
lum=None
,
tint=None
)
[source]
¶
alphaBiLevel
¶
Values must be of type <class ‘openpyxl.drawing.effect.AlphaBiLevelEffect’>
alphaCeiling
¶
Values must be of type <class ‘openpyxl.drawing.effect.AlphaCeilingEffect’>
alphaFloor
¶
Values must be of type <class ‘openpyxl.drawing.effect.AlphaFloorEffect’>
alphaInv
¶
Values must be of type <class ‘openpyxl.drawing.effect.AlphaInverseEffect’>
alphaMod
¶
Values must be of type <class ‘openpyxl.drawing.effect.AlphaModulateEffect’>
alphaModFix
¶
Values must be of type <class ‘openpyxl.drawing.effect.AlphaModulateFixedEffect’>
alphaRepl
¶
Values must be of type <class ‘openpyxl.drawing.effect.AlphaReplaceEffect’>
biLevel
¶
Values must be of type <class ‘openpyxl.drawing.effect.BiLevelEffect’>
blur
¶
Values must be of type <class ‘openpyxl.drawing.effect.BlurEffect’>
clrChange
¶
Values must be of type <class ‘openpyxl.drawing.effect.ColorChangeEffect’>
clrRepl
¶
Values must be of type <class ‘openpyxl.drawing.effect.ColorReplaceEffect’>
cstate
¶
Value must be one of {‘hqprint’, ‘screen’, ‘email’, ‘print’}
duotone
¶
Values must be of type <class ‘openpyxl.drawing.effect.DuotoneEffect’>
embed
¶
Values must be of type <class ‘str’>
extLst
¶
Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>
fillOverlay
¶
Values must be of type <class ‘openpyxl.drawing.effect.FillOverlayEffect’>
grayscl
¶
Values must be of type <class ‘openpyxl.drawing.effect.GrayscaleEffect’>
hsl
¶
Values must be of type <class ‘openpyxl.drawing.effect.HSLEffect’>
link
¶
Values must be of type <class ‘str’>
lum
¶
Values must be of type <class ‘openpyxl.drawing.effect.LuminanceEffect’>
namespace
= 'http://schemas.openxmlformats.org/drawingml/2006/main'
¶
noAdjustHandles
¶
Values must be of type <class ‘bool’>
noChangeArrowheads
¶
Values must be of type <class ‘bool’>
noChangeAspect
¶
Values must be of type <class ‘bool’>
noChangeShapeType
¶
Values must be of type <class ‘bool’>
noEditPoints
¶
Values must be of type <class ‘bool’>
noGrp
¶
Values must be of type <class ‘bool’>
noMove
¶
Values must be of type <class ‘bool’>
noResize
¶
Values must be of type <class ‘bool’>
noRot
¶
Values must be of type <class ‘bool’>
noSelect
¶
Values must be of type <class ‘bool’>
tagname
= 'blip'
¶
tint
¶
Values must be of type <class ‘openpyxl.drawing.effect.TintEffect’>
openpyxl.drawing.fill.
BlipFillProperties
(
dpi=None
,
rotWithShape=None
,
blip=None
,
tile=None
,
stretch=<openpyxl.drawing.fill.StretchInfoProperties object> Parameters: fillRect=<openpyxl.drawing.fill.RelativeRect object> Parameters: l=None
,
t=None
,
r=None
,
b=None
,
srcRect=None
)
[source]
¶
blip
¶
Values must be of type <class ‘openpyxl.drawing.fill.Blip’>
dpi
¶
Values must be of type <class ‘int’>
rotWithShape
¶
Values must be of type <class ‘bool’>
srcRect
¶
Values must be of type <class ‘openpyxl.drawing.fill.RelativeRect’>
stretch
¶
Values must be of type <class ‘openpyxl.drawing.fill.StretchInfoProperties’>
tagname
= 'blipFill'
¶
tile
¶
Values must be of type <class ‘openpyxl.drawing.fill.TileInfoProperties’>
openpyxl.drawing.fill.
GradientFillProperties
(
flip=None
,
rotWithShape=None
,
gsLst=()
,
lin=None
,
path=None
,
tileRect=None
)
[source]
¶
flip
¶
Value must be one of {‘y’, ‘xy’, ‘x’}
gsLst
¶
Wrap a sequence in an containing object
lin
¶
Values must be of type <class ‘openpyxl.drawing.fill.LinearShadeProperties’>
linear
¶
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”)
namespace
= 'http://schemas.openxmlformats.org/drawingml/2006/main'
¶
path
¶
Values must be of type <class ‘openpyxl.drawing.fill.PathShadeProperties’>
rotWithShape
¶
Values must be of type <class ‘bool’>
stop_list
¶
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”)
tagname
= 'gradFill'
¶
tileRect
¶
Values must be of type <class ‘openpyxl.drawing.fill.RelativeRect’>
openpyxl.drawing.fill.
GradientStop
(
pos=None
,
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'
¶
pos
¶
Values must be of type <class ‘float’>
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
= 'gs'
¶
ang
¶
Values must be of type <class ‘int’>
namespace
= 'http://schemas.openxmlformats.org/drawingml/2006/main'
¶
scaled
¶
Values must be of type <class ‘bool’>
tagname
= 'lin'
¶
fillToRect
¶
Values must be of type <class ‘openpyxl.drawing.fill.RelativeRect’>
namespace
= 'http://schemas.openxmlformats.org/drawingml/2006/main'
¶
path
¶
Value must be one of {‘shape’, ‘circle’, ‘rect’}
tagname
= 'path'
¶
openpyxl.drawing.fill.
PatternFillProperties
(
prst=None
,
fgClr=None
,
bgClr=None
)
[source]
¶
background
¶
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”)
bgClr
¶
Values must be of type <class ‘openpyxl.drawing.colors.ColorChoice’>
fgClr
¶
Values must be of type <class ‘openpyxl.drawing.colors.ColorChoice’>
foreground
¶
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”)
namespace
= 'http://schemas.openxmlformats.org/drawingml/2006/main'
¶
preset
¶
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”)
prst
¶
Value must be one of {‘dashUpDiag’, ‘narVert’, ‘horz’, ‘smGrid’, ‘pct70’, ‘pct25’, ‘narHorz’, ‘pct75’, ‘dkHorz’, ‘dotGrid’, ‘dotDmnd’, ‘plaid’, ‘horzBrick’, ‘wave’, ‘vert’, ‘dashVert’, ‘upDiag’, ‘pct5’, ‘ltHorz’, ‘dnDiag’, ‘trellis’, ‘pct40’, ‘pct50’, ‘zigZag’, ‘smConfetti’, ‘cross’, ‘smCheck’, ‘pct10’, ‘ltVert’, ‘ltDnDiag’, ‘lgConfetti’, ‘wdDnDiag’, ‘pct60’, ‘lgGrid’, ‘diagBrick’, ‘pct30’, ‘divot’, ‘solidDmnd’, ‘pct90’, ‘diagCross’, ‘lgCheck’, ‘weave’, ‘pct80’, ‘pct20’, ‘dashHorz’, ‘dkVert’, ‘sphere’, ‘dashDnDiag’, ‘openDmnd’, ‘dkDnDiag’, ‘dkUpDiag’, ‘wdUpDiag’, ‘shingle’, ‘ltUpDiag’}
tagname
= 'pattFill'
¶
b
¶
Values must be of type <class ‘float’>
bottom
¶
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”)
l
¶
Values must be of type <class ‘float’>
left
¶
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”)
namespace
= 'http://schemas.openxmlformats.org/drawingml/2006/main'
¶
r
¶
Values must be of type <class ‘float’>
right
¶
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”)
t
¶
Values must be of type <class ‘float’>
tagname
= 'rect'
¶
top
¶
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”)
openpyxl.drawing.fill.
SolidColorFillProperties
(
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’>
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
= 'solidFill'
¶
openpyxl.drawing.fill.
StretchInfoProperties
(
fillRect=<openpyxl.drawing.fill.RelativeRect object> Parameters: l=None
,
t=None
,
r=None
,
b=None
)
[source]
¶
fillRect
¶
Values must be of type <class ‘openpyxl.drawing.fill.RelativeRect’>
namespace
= 'http://schemas.openxmlformats.org/drawingml/2006/main'
¶
tagname
= 'stretch'
¶
openpyxl.drawing.fill.
TileInfoProperties
(
tx=None
,
ty=None
,
sx=None
,
sy=None
,
flip=None
,
algn=None
)
[source]
¶
algn
¶
Value must be one of {‘l’, ‘br’, ‘bl’, ‘r’, ‘t’, ‘tl’, ‘b’, ‘ctr’, ‘tr’}
flip
¶
Value must be one of {‘y’, ‘xy’, ‘x’}
sx
¶
Values must be of type <class ‘int’>
sy
¶
Values must be of type <class ‘int’>
tx
¶
Values must be of type <class ‘int’>
ty
¶
Values must be of type <class ‘int’>