openpyxl.drawing.effect模块¶
- class openpyxl.drawing.effect.AlphaBiLevelEffect(thresh=None)[源代码]¶
基类：
openpyxl.descriptors.serialisable.Serialisable- thresh¶
值的类型必须小于class“int”>
- class openpyxl.drawing.effect.AlphaModulateEffect(cont=None)[源代码]¶
基类：
openpyxl.descriptors.serialisable.Serialisable- cont¶
值的类型必须小于“openpyxl.drawing.effect.effectcontainer”>
- class openpyxl.drawing.effect.AlphaModulateFixedEffect(amt=None)[源代码]¶
基类：
openpyxl.descriptors.serialisable.Serialisable- amt¶
值的类型必须小于class“int”>
- class openpyxl.drawing.effect.AlphaReplaceEffect(a=None)[源代码]¶
基类：
openpyxl.descriptors.serialisable.Serialisable- a¶
值的类型必须小于class“int”>
- class openpyxl.drawing.effect.BiLevelEffect(thresh=None)[源代码]¶
基类：
openpyxl.descriptors.serialisable.Serialisable- thresh¶
值的类型必须小于class“int”>
- class openpyxl.drawing.effect.BlurEffect(rad=None, grow=None)[源代码]¶
基类：
openpyxl.descriptors.serialisable.Serialisable- grow¶
值的类型必须小于class'bool'>
- rad¶
值的类型必须小于class“float”>
- class openpyxl.drawing.effect.ColorChangeEffect(useA=None, clrFrom=None, clrTo=None)[源代码]¶
基类：
openpyxl.descriptors.serialisable.Serialisable- clrFrom¶
值的类型必须小于class“openpyxl.drawing.effect.color”>
- clrTo¶
值的类型必须小于class“openpyxl.drawing.effect.color”>
- useA¶
值的类型必须小于class'bool'>
- class openpyxl.drawing.effect.EffectContainer(type=None, name=None)[源代码]¶
基类：
openpyxl.descriptors.serialisable.Serialisable- name¶
值的类型必须小于class'str'>
- type¶
值必须是{‘sib’，‘tree’}之一
- class openpyxl.drawing.effect.EffectList(blur=None, fillOverlay=None, glow=None, innerShdw=None, outerShdw=None, prstShdw=None, reflection=None, softEdge=None)[源代码]¶
基类：
openpyxl.descriptors.serialisable.Serialisable- blur¶
值的类型必须小于class“openpyxl.drawing.effect.blurefect”>
- fillOverlay¶
值的类型必须小于class“openpyxl.drawing.effect.fillOverlayeffect”>
- glow¶
值的类型必须小于class“openpyxl.drawing.effect.gloweffect”>
- innerShdw¶
值的类型必须小于class“openpyxl.drawing.effect.innershadoweffect”>
- outerShdw¶
值的类型必须小于class“openpyxl.drawing.effect.outershadow”>
- prstShdw¶
值的类型必须小于class“openpyxl.drawing.effect.presetshadoweffect”>
- reflection¶
值的类型必须小于“openpyxl.drawing.effect.reflectioneffect”>
- softEdge¶
值的类型必须小于class“openpyxl.drawing.effect.softedgeseffect”>
- class openpyxl.drawing.effect.FillOverlayEffect(blend=None)[源代码]¶
基类：
openpyxl.descriptors.serialisable.Serialisable- blend¶
Value must be one of {'lighten', 'darken', 'mult', 'over', 'screen'}
- class openpyxl.drawing.effect.GlowEffect(rad=None, **kw)[源代码]¶
基类：
openpyxl.drawing.colors.ColorChoice- hslClr¶
值的类型必须小于class“openpyxl.drawing.colors.hslcolor”>
- prstClr¶
Value must be one of {'orchid', 'ltSalmon', 'ltCyan', 'rosyBrown', 'dkGrey', 'lightGray', 'grey', 'saddleBrown', 'orange', 'chocolate', 'brown', 'dodgerBlue', 'gray', 'burlyWood', 'antiqueWhite', 'moccasin', 'bisque', 'dkBlue', 'medSpringGreen', 'aliceBlue', 'fuchsia', 'navy', 'blue', 'tomato', 'powderBlue', 'dkOliveGreen', 'limeGreen', 'dkMagenta', 'ltSlateGray', 'indianRed', 'mistyRose', 'ltYellow', 'paleGreen', 'darkSlateBlue', 'yellow', 'lightSlateGray', 'azure', 'orangeRed', 'mediumAquamarine', 'violet', 'dkSlateGray', 'forestGreen', 'wheat', 'ltSkyBlue', 'darkSlateGray', 'ltGrey', 'mediumVioletRed', 'darkGreen', 'plum', 'paleTurquoise', 'indigo', 'thistle', 'navajoWhite', 'lightCoral', 'lightYellow', 'coral', 'hotPink', 'paleVioletRed', 'dkTurquoise', 'dkSlateGrey', 'linen', 'ltPink', 'darkOrchid', 'ltGoldenrodYellow', 'ltGreen', 'pink', 'ltBlue', 'dkKhaki', 'royalBlue', 'turquoise', 'lightSteelBlue', 'yellowGreen', 'lavender', 'ltCoral', 'mediumOrchid', 'medAquamarine', 'dkCyan', 'greenYellow', 'slateBlue', 'darkGray', 'lightSkyBlue', 'oliveDrab', 'dimGrey', 'darkMagenta', 'mediumBlue', 'medSlateBlue', 'dkSalmon', 'lightSeaGreen', 'skyBlue', 'ghostWhite', 'tan', 'medVioletRed', 'dkSeaGreen', 'darkSeaGreen', 'peachPuff', 'mediumTurquoise', 'magenta', 'blanchedAlmond', 'aquamarine', 'papayaWhip', 'red', 'goldenrod', 'springGreen', 'steelBlue', 'lemonChiffon', 'darkViolet', 'maroon', 'darkCyan', 'mediumSeaGreen', 'ltSeaGreen', 'ltSlateGrey', 'cyan', 'darkGrey', 'dkSlateBlue', 'lightGreen', 'dkRed', 'gainsboro', 'mintCream', 'dimGray', 'deepPink', 'paleGoldenrod', 'dkGray', 'beige', 'cornflowerBlue', 'dkOrchid', 'lime', 'medOrchid', 'green', 'floralWhite', 'crimson', 'mediumSlateBlue', 'olive', 'salmon', 'darkGoldenrod', 'darkKhaki', 'lightGoldenrodYellow', 'lightPink', 'teal', 'firebrick', 'ivory', 'white', 'silver', 'darkSlateGrey', 'cadetBlue', 'dkGreen', 'dkViolet', 'dkOrange', 'lightSalmon', 'snow', 'lavenderBlush', 'chartreuse', 'darkBlue', 'medBlue', 'honeydew', 'mediumPurple', 'medSeaGreen', 'aqua', 'medPurple', 'darkRed', 'midnightBlue', 'lightGrey', 'oldLace', 'lightCyan', 'slateGrey', 'whiteSmoke', 'dkGoldenrod', 'sandyBrown', 'darkSalmon', 'blueViolet', 'sienna', 'darkOliveGreen', 'seaShell', 'lawnGreen', 'slateGray', 'deepSkyBlue', 'gold', 'darkTurquoise', 'mediumSpringGreen', 'ltGray', 'cornsilk', 'darkOrange', 'peru', 'black', 'seaGreen', 'khaki', 'lightSlateGrey', 'medTurquoise', 'ltSteelBlue', 'lightBlue', 'purple'}
- rad¶
值的类型必须小于class“float”>
- schemeClr¶
值的类型必须小于class“openpyxl.drawing.colors.schemecolor”>
- scrgbClr¶
值的类型必须小于class“openpyxl.drawing.colors.rgbPercent”>
- srgbClr¶
值的类型必须小于class'str'>
- sysClr¶
值的类型必须小于class“openpyxl.drawing.colors.systemcolor”>
- class openpyxl.drawing.effect.GrayscaleEffect[源代码]¶
基类：
openpyxl.descriptors.serialisable.Serialisable- tagname = 'grayscl'¶
- class openpyxl.drawing.effect.HSLEffect(hue=None, sat=None, lum=None)[源代码]¶
基类：
openpyxl.descriptors.serialisable.Serialisable- hue¶
值的类型必须小于class“int”>
- lum¶
值的类型必须小于class“int”>
- sat¶
值的类型必须小于class“int”>
- class openpyxl.drawing.effect.InnerShadowEffect(blurRad=None, dist=None, dir=None, **kw)[源代码]¶
基类：
openpyxl.drawing.colors.ColorChoice- blurRad¶
值的类型必须小于class“float”>
- dir¶
值的类型必须小于class“int”>
- dist¶
值的类型必须小于class“float”>
- hslClr¶
值的类型必须小于class“openpyxl.drawing.colors.hslcolor”>
- prstClr¶
Value must be one of {'orchid', 'ltSalmon', 'ltCyan', 'rosyBrown', 'dkGrey', 'lightGray', 'grey', 'saddleBrown', 'orange', 'chocolate', 'brown', 'dodgerBlue', 'gray', 'burlyWood', 'antiqueWhite', 'moccasin', 'bisque', 'dkBlue', 'medSpringGreen', 'aliceBlue', 'fuchsia', 'navy', 'blue', 'tomato', 'powderBlue', 'dkOliveGreen', 'limeGreen', 'dkMagenta', 'ltSlateGray', 'indianRed', 'mistyRose', 'ltYellow', 'paleGreen', 'darkSlateBlue', 'yellow', 'lightSlateGray', 'azure', 'orangeRed', 'mediumAquamarine', 'violet', 'dkSlateGray', 'forestGreen', 'wheat', 'ltSkyBlue', 'darkSlateGray', 'ltGrey', 'mediumVioletRed', 'darkGreen', 'plum', 'paleTurquoise', 'indigo', 'thistle', 'navajoWhite', 'lightCoral', 'lightYellow', 'coral', 'hotPink', 'paleVioletRed', 'dkTurquoise', 'dkSlateGrey', 'linen', 'ltPink', 'darkOrchid', 'ltGoldenrodYellow', 'ltGreen', 'pink', 'ltBlue', 'dkKhaki', 'royalBlue', 'turquoise', 'lightSteelBlue', 'yellowGreen', 'lavender', 'ltCoral', 'mediumOrchid', 'medAquamarine', 'dkCyan', 'greenYellow', 'slateBlue', 'darkGray', 'lightSkyBlue', 'oliveDrab', 'dimGrey', 'darkMagenta', 'mediumBlue', 'medSlateBlue', 'dkSalmon', 'lightSeaGreen', 'skyBlue', 'ghostWhite', 'tan', 'medVioletRed', 'dkSeaGreen', 'darkSeaGreen', 'peachPuff', 'mediumTurquoise', 'magenta', 'blanchedAlmond', 'aquamarine', 'papayaWhip', 'red', 'goldenrod', 'springGreen', 'steelBlue', 'lemonChiffon', 'darkViolet', 'maroon', 'darkCyan', 'mediumSeaGreen', 'ltSeaGreen', 'ltSlateGrey', 'cyan', 'darkGrey', 'dkSlateBlue', 'lightGreen', 'dkRed', 'gainsboro', 'mintCream', 'dimGray', 'deepPink', 'paleGoldenrod', 'dkGray', 'beige', 'cornflowerBlue', 'dkOrchid', 'lime', 'medOrchid', 'green', 'floralWhite', 'crimson', 'mediumSlateBlue', 'olive', 'salmon', 'darkGoldenrod', 'darkKhaki', 'lightGoldenrodYellow', 'lightPink', 'teal', 'firebrick', 'ivory', 'white', 'silver', 'darkSlateGrey', 'cadetBlue', 'dkGreen', 'dkViolet', 'dkOrange', 'lightSalmon', 'snow', 'lavenderBlush', 'chartreuse', 'darkBlue', 'medBlue', 'honeydew', 'mediumPurple', 'medSeaGreen', 'aqua', 'medPurple', 'darkRed', 'midnightBlue', 'lightGrey', 'oldLace', 'lightCyan', 'slateGrey', 'whiteSmoke', 'dkGoldenrod', 'sandyBrown', 'darkSalmon', 'blueViolet', 'sienna', 'darkOliveGreen', 'seaShell', 'lawnGreen', 'slateGray', 'deepSkyBlue', 'gold', 'darkTurquoise', 'mediumSpringGreen', 'ltGray', 'cornsilk', 'darkOrange', 'peru', 'black', 'seaGreen', 'khaki', 'lightSlateGrey', 'medTurquoise', 'ltSteelBlue', 'lightBlue', 'purple'}
- schemeClr¶
值的类型必须小于class“openpyxl.drawing.colors.schemecolor”>
- scrgbClr¶
值的类型必须小于class“openpyxl.drawing.colors.rgbPercent”>
- srgbClr¶
值的类型必须小于class'str'>
- sysClr¶
值的类型必须小于class“openpyxl.drawing.colors.systemcolor”>
- class openpyxl.drawing.effect.LuminanceEffect(bright=0, contrast=0)[源代码]¶
基类：
openpyxl.descriptors.serialisable.Serialisable- bright¶
值的类型必须小于class“int”>
- contrast¶
值的类型必须小于class“int”>
- tagname = 'lum'¶
- class openpyxl.drawing.effect.OuterShadow(blurRad=None, dist=None, dir=None, sx=None, sy=None, kx=None, ky=None, algn=None, rotWithShape=None, **kw)[源代码]¶
基类：
openpyxl.drawing.colors.ColorChoice- algn¶
Value must be one of {'tr', 'ctr', 'r', 'br', 'l', 't', 'b', 'bl', 'tl'}
- blurRad¶
值的类型必须小于class“float”>
- dir¶
值的类型必须小于class“int”>
- dist¶
值的类型必须小于class“float”>
- hslClr¶
值的类型必须小于class“openpyxl.drawing.colors.hslcolor”>
- kx¶
值的类型必须小于class“int”>
- ky¶
值的类型必须小于class“int”>
- prstClr¶
Value must be one of {'orchid', 'ltSalmon', 'ltCyan', 'rosyBrown', 'dkGrey', 'lightGray', 'grey', 'saddleBrown', 'orange', 'chocolate', 'brown', 'dodgerBlue', 'gray', 'burlyWood', 'antiqueWhite', 'moccasin', 'bisque', 'dkBlue', 'medSpringGreen', 'aliceBlue', 'fuchsia', 'navy', 'blue', 'tomato', 'powderBlue', 'dkOliveGreen', 'limeGreen', 'dkMagenta', 'ltSlateGray', 'indianRed', 'mistyRose', 'ltYellow', 'paleGreen', 'darkSlateBlue', 'yellow', 'lightSlateGray', 'azure', 'orangeRed', 'mediumAquamarine', 'violet', 'dkSlateGray', 'forestGreen', 'wheat', 'ltSkyBlue', 'darkSlateGray', 'ltGrey', 'mediumVioletRed', 'darkGreen', 'plum', 'paleTurquoise', 'indigo', 'thistle', 'navajoWhite', 'lightCoral', 'lightYellow', 'coral', 'hotPink', 'paleVioletRed', 'dkTurquoise', 'dkSlateGrey', 'linen', 'ltPink', 'darkOrchid', 'ltGoldenrodYellow', 'ltGreen', 'pink', 'ltBlue', 'dkKhaki', 'royalBlue', 'turquoise', 'lightSteelBlue', 'yellowGreen', 'lavender', 'ltCoral', 'mediumOrchid', 'medAquamarine', 'dkCyan', 'greenYellow', 'slateBlue', 'darkGray', 'lightSkyBlue', 'oliveDrab', 'dimGrey', 'darkMagenta', 'mediumBlue', 'medSlateBlue', 'dkSalmon', 'lightSeaGreen', 'skyBlue', 'ghostWhite', 'tan', 'medVioletRed', 'dkSeaGreen', 'darkSeaGreen', 'peachPuff', 'mediumTurquoise', 'magenta', 'blanchedAlmond', 'aquamarine', 'papayaWhip', 'red', 'goldenrod', 'springGreen', 'steelBlue', 'lemonChiffon', 'darkViolet', 'maroon', 'darkCyan', 'mediumSeaGreen', 'ltSeaGreen', 'ltSlateGrey', 'cyan', 'darkGrey', 'dkSlateBlue', 'lightGreen', 'dkRed', 'gainsboro', 'mintCream', 'dimGray', 'deepPink', 'paleGoldenrod', 'dkGray', 'beige', 'cornflowerBlue', 'dkOrchid', 'lime', 'medOrchid', 'green', 'floralWhite', 'crimson', 'mediumSlateBlue', 'olive', 'salmon', 'darkGoldenrod', 'darkKhaki', 'lightGoldenrodYellow', 'lightPink', 'teal', 'firebrick', 'ivory', 'white', 'silver', 'darkSlateGrey', 'cadetBlue', 'dkGreen', 'dkViolet', 'dkOrange', 'lightSalmon', 'snow', 'lavenderBlush', 'chartreuse', 'darkBlue', 'medBlue', 'honeydew', 'mediumPurple', 'medSeaGreen', 'aqua', 'medPurple', 'darkRed', 'midnightBlue', 'lightGrey', 'oldLace', 'lightCyan', 'slateGrey', 'whiteSmoke', 'dkGoldenrod', 'sandyBrown', 'darkSalmon', 'blueViolet', 'sienna', 'darkOliveGreen', 'seaShell', 'lawnGreen', 'slateGray', 'deepSkyBlue', 'gold', 'darkTurquoise', 'mediumSpringGreen', 'ltGray', 'cornsilk', 'darkOrange', 'peru', 'black', 'seaGreen', 'khaki', 'lightSlateGrey', 'medTurquoise', 'ltSteelBlue', 'lightBlue', 'purple'}
- rotWithShape¶
值的类型必须小于class'bool'>
- schemeClr¶
值的类型必须小于class“openpyxl.drawing.colors.schemecolor”>
- scrgbClr¶
值的类型必须小于class“openpyxl.drawing.colors.rgbPercent”>
- srgbClr¶
值的类型必须小于class'str'>
- sx¶
值的类型必须小于class“int”>
- sy¶
值的类型必须小于class“int”>
- sysClr¶
值的类型必须小于class“openpyxl.drawing.colors.systemcolor”>
- tagname = 'outerShdw'¶
- class openpyxl.drawing.effect.PresetShadowEffect(prst=None, dist=None, dir=None, **kw)[源代码]¶
基类：
openpyxl.drawing.colors.ColorChoice- dir¶
值的类型必须小于class“int”>
- dist¶
值的类型必须小于class“float”>
- hslClr¶
值的类型必须小于class“openpyxl.drawing.colors.hslcolor”>
- prst¶
Value must be one of {'shdw16', 'shdw11', 'shdw5', 'shdw3', 'shdw17', 'shdw1', 'shdw13', 'shdw20', 'shdw7', 'shdw15', 'shdw8', 'shdw6', 'shdw4', 'shdw14', 'shdw9', 'shdw19', 'shdw2', 'shdw10', 'shdw18', 'shdw12'}
- prstClr¶
Value must be one of {'orchid', 'ltSalmon', 'ltCyan', 'rosyBrown', 'dkGrey', 'lightGray', 'grey', 'saddleBrown', 'orange', 'chocolate', 'brown', 'dodgerBlue', 'gray', 'burlyWood', 'antiqueWhite', 'moccasin', 'bisque', 'dkBlue', 'medSpringGreen', 'aliceBlue', 'fuchsia', 'navy', 'blue', 'tomato', 'powderBlue', 'dkOliveGreen', 'limeGreen', 'dkMagenta', 'ltSlateGray', 'indianRed', 'mistyRose', 'ltYellow', 'paleGreen', 'darkSlateBlue', 'yellow', 'lightSlateGray', 'azure', 'orangeRed', 'mediumAquamarine', 'violet', 'dkSlateGray', 'forestGreen', 'wheat', 'ltSkyBlue', 'darkSlateGray', 'ltGrey', 'mediumVioletRed', 'darkGreen', 'plum', 'paleTurquoise', 'indigo', 'thistle', 'navajoWhite', 'lightCoral', 'lightYellow', 'coral', 'hotPink', 'paleVioletRed', 'dkTurquoise', 'dkSlateGrey', 'linen', 'ltPink', 'darkOrchid', 'ltGoldenrodYellow', 'ltGreen', 'pink', 'ltBlue', 'dkKhaki', 'royalBlue', 'turquoise', 'lightSteelBlue', 'yellowGreen', 'lavender', 'ltCoral', 'mediumOrchid', 'medAquamarine', 'dkCyan', 'greenYellow', 'slateBlue', 'darkGray', 'lightSkyBlue', 'oliveDrab', 'dimGrey', 'darkMagenta', 'mediumBlue', 'medSlateBlue', 'dkSalmon', 'lightSeaGreen', 'skyBlue', 'ghostWhite', 'tan', 'medVioletRed', 'dkSeaGreen', 'darkSeaGreen', 'peachPuff', 'mediumTurquoise', 'magenta', 'blanchedAlmond', 'aquamarine', 'papayaWhip', 'red', 'goldenrod', 'springGreen', 'steelBlue', 'lemonChiffon', 'darkViolet', 'maroon', 'darkCyan', 'mediumSeaGreen', 'ltSeaGreen', 'ltSlateGrey', 'cyan', 'darkGrey', 'dkSlateBlue', 'lightGreen', 'dkRed', 'gainsboro', 'mintCream', 'dimGray', 'deepPink', 'paleGoldenrod', 'dkGray', 'beige', 'cornflowerBlue', 'dkOrchid', 'lime', 'medOrchid', 'green', 'floralWhite', 'crimson', 'mediumSlateBlue', 'olive', 'salmon', 'darkGoldenrod', 'darkKhaki', 'lightGoldenrodYellow', 'lightPink', 'teal', 'firebrick', 'ivory', 'white', 'silver', 'darkSlateGrey', 'cadetBlue', 'dkGreen', 'dkViolet', 'dkOrange', 'lightSalmon', 'snow', 'lavenderBlush', 'chartreuse', 'darkBlue', 'medBlue', 'honeydew', 'mediumPurple', 'medSeaGreen', 'aqua', 'medPurple', 'darkRed', 'midnightBlue', 'lightGrey', 'oldLace', 'lightCyan', 'slateGrey', 'whiteSmoke', 'dkGoldenrod', 'sandyBrown', 'darkSalmon', 'blueViolet', 'sienna', 'darkOliveGreen', 'seaShell', 'lawnGreen', 'slateGray', 'deepSkyBlue', 'gold', 'darkTurquoise', 'mediumSpringGreen', 'ltGray', 'cornsilk', 'darkOrange', 'peru', 'black', 'seaGreen', 'khaki', 'lightSlateGrey', 'medTurquoise', 'ltSteelBlue', 'lightBlue', 'purple'}
- schemeClr¶
值的类型必须小于class“openpyxl.drawing.colors.schemecolor”>
- scrgbClr¶
值的类型必须小于class“openpyxl.drawing.colors.rgbPercent”>
- srgbClr¶
值的类型必须小于class'str'>
- sysClr¶
值的类型必须小于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)[源代码]¶
基类：
openpyxl.descriptors.serialisable.Serialisable- algn¶
Value must be one of {'tr', 'ctr', 'r', 'br', 'l', 't', 'b', 'bl', 'tl'}
- blurRad¶
值的类型必须小于class“float”>
- dir¶
值的类型必须小于class“int”>
- dist¶
值的类型必须小于class“float”>
- endA¶
值的类型必须小于class“int”>
- endPos¶
值的类型必须小于class“int”>
- fadeDir¶
值的类型必须小于class“int”>
- kx¶
值的类型必须小于class“int”>
- ky¶
值的类型必须小于class“int”>
- rotWithShape¶
值的类型必须小于class'bool'>
- stA¶
值的类型必须小于class“int”>
- stPos¶
值的类型必须小于class“int”>
- sx¶
值的类型必须小于class“int”>
- sy¶
值的类型必须小于class“int”>
- class openpyxl.drawing.effect.SoftEdgesEffect(rad=None)[源代码]¶
基类：
openpyxl.descriptors.serialisable.Serialisable- rad¶
值的类型必须小于class“float”>
