OpenPyXL 3.0.7
  • 教程
  • 简单用法
  • 性能
  • 优化模式
  • 插入和删除行和列,移动单元格范围
  • 操纵 Pandas 和 NumPy
  • 图表
  • 注释
  • 操控样式
  • 额外工作表特性
  • 条件格式化
  • 数据透视表
  • 打印设置
  • 使用过滤器和排序
  • 验证单元格
  • 定义名称
  • 工作表表格
  • 剖析公式
  • 日期和时间
  • 保护
  • 开发
  • openpyxl 包
  • 3.0.7 (2021-03-09)
  • 3.0.6 (2021-01-14)
  • 3.0.5 (2020-08-21)
  • 3.0.4 (2020-06-24)
  • 3.0.3 (2020-01-20)
  • 3.0.2 (2019-11-25)
  • 3.0.1 (2019-11-14)
  • 3.0.0 (2019-09-25)
  • 2.6.4 (2019-09-25)
  • 2.6.3 (2019-08-19)
  • 2.6.2 (2019-03-29)
  • 2.6.1 (2019-03-04)
  • 2.6.0 (2019-02-06)
  • 2.6.-b1 (2019-01-08)
  • 2.6-a1 (2018-11-21)
  • 2.5.14 (2019-01-23)
  • 2.5.13 (brown bag)
  • 2.5.12 (2018-11-29)
  • 2.5.11 (2018-11-21)
  • 2.5.10 (2018-11-13)
  • 2.5.9 (2018-10-19)
  • 2.5.8 (2018-09-25)
  • 2.5.7 (2018-09-13)
  • 2.5.6 (2018-08-30)
  • 2.5.5 (2018-08-04)
  • 2.5.4 (2018-06-07)
  • 2.5.3 (2018-04-18)
  • 2.5.2 (2018-04-06)
  • 2.5.1 (2018-03-12)
  • 2.5.0 (2018-01-24)
  • 2.5.0-b2 (2018-01-19)
  • 2.5.0-b1 (2017-10-19)
  • 2.5.0-a3 (2017-08-14)
  • 2.5.0-a2 (2017-06-25)
  • 2.5.0-a1 (2017-05-30)
  • 2.4.11 (2018-01-24)
  • 2.4.10 (2018-01-19)
  • 2.4.9 (2017-10-19)
  • 2.4.8 (2017-05-30)
  • 2.4.7 (2017-04-24)
  • 2.4.6 (2017-04-14)
  • 2.4.5 (2017-03-07)
  • 2.4.4 (2017-02-23)
  • 2.4.3 (未发行)
  • 2.4.2 (2017-01-31)
  • 2.4.1 (2016-11-23)
  • 2.4.0 (2016-09-15)
  • 2.4.0-b1 (2016-06-08)
  • 2.4.0-a1 (2016-04-11)
  • 2.3.5 (2016-04-11)
  • 2.3.4 (2016-03-16)
  • 2.3.3 (2016-01-18)
  • 2.3.2 (2015-12-07)
  • 2.3.1 (2015-11-20)
  • 2.3.0 (2015-10-20)
  • 2.3.0-b2 (2015-09-04)
  • 2.3.0-b1 (2015-06-29)
  • 2.2.6 (未发行)
  • 2.2.5 (2015-06-29)
  • 2.2.4 (2015-06-17)
  • 2.2.3 (2015-05-26)
  • 2.2.2 (2015-04-28)
  • 2.2.1 (2015-03-31)
  • 2.2.0 (2015-03-11)
  • 2.2.0-b1 (2015-02-18)
  • 2.1.5 (2015-02-18)
  • 2.1.4 (2014-12-16)
  • 2.1.3 (2014-12-09)
  • 2.1.2 (2014-10-23)
  • 2.1.1 (2014-10-08)
  • 2.1.0 (2014-09-21)
  • 2.0.5 (2014-08-08)
  • 2.0.4 (2014-06-25)
  • 2.0.3 (2014-05-22)
  • 2.0.2 (2014-05-13)
  • 2.0.1 (2014-05-13) brown bag
  • 2.0.0 (2014-05-13) brown bag
  • 1.8.6 (2014-05-05)
  • 1.8.5 (2014-03-25)
  • 1.8.4 (2014-02-25)
  • 1.8.3 (2014-02-09)
  • 1.8.2 (2014-01-17)
  • 1.8.1 (2014-01-14)
  • 1.8.0 (2014-01-08)
  • 1.7.0 (2013-10-31)
  • openpyxl.drawing.effect 模块

    class openpyxl.drawing.effect. AlphaBiLevelEffect ( thresh=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    thresh

    Values must be of type <class ‘int’>

    class openpyxl.drawing.effect. AlphaCeilingEffect [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    class openpyxl.drawing.effect. AlphaFloorEffect [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    class openpyxl.drawing.effect. AlphaInverseEffect [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    class openpyxl.drawing.effect. AlphaModulateEffect ( cont=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    cont

    Values must be of type <class ‘openpyxl.drawing.effect.EffectContainer’>

    class openpyxl.drawing.effect. AlphaModulateFixedEffect ( amt=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    amt

    Values must be of type <class ‘int’>

    class openpyxl.drawing.effect. AlphaReplaceEffect ( a=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    a

    Values must be of type <class ‘int’>

    class openpyxl.drawing.effect. BiLevelEffect ( thresh=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    thresh

    Values must be of type <class ‘int’>

    class openpyxl.drawing.effect. BlurEffect ( rad=None , grow=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    grow

    Values must be of type <class ‘bool’>

    rad

    Values must be of type <class ‘float’>

    class openpyxl.drawing.effect. 颜色 [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    class openpyxl.drawing.effect. ColorChangeEffect ( useA=None , clrFrom=None , clrTo=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    clrFrom

    Values must be of type <class ‘openpyxl.drawing.effect.Color’>

    clrTo

    Values must be of type <class ‘openpyxl.drawing.effect.Color’>

    useA

    Values must be of type <class ‘bool’>

    class openpyxl.drawing.effect. ColorReplaceEffect [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    class openpyxl.drawing.effect. DuotoneEffect [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    class openpyxl.drawing.effect. EffectContainer ( type=None , name=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    name

    Values must be of type <class ‘str’>

    type

    Value must be one of {‘tree’, ‘sib’}

    class openpyxl.drawing.effect. EffectList ( blur=None , fillOverlay=None , glow=None , innerShdw=None , outerShdw=None , prstShdw=None , reflection=None , softEdge=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    blur

    Values must be of type <class ‘openpyxl.drawing.effect.BlurEffect’>

    fillOverlay

    Values must be of type <class ‘openpyxl.drawing.effect.FillOverlayEffect’>

    glow

    Values must be of type <class ‘openpyxl.drawing.effect.GlowEffect’>

    innerShdw

    Values must be of type <class ‘openpyxl.drawing.effect.InnerShadowEffect’>

    outerShdw

    Values must be of type <class ‘openpyxl.drawing.effect.OuterShadow’>

    prstShdw

    Values must be of type <class ‘openpyxl.drawing.effect.PresetShadowEffect’>

    reflection

    Values must be of type <class ‘openpyxl.drawing.effect.ReflectionEffect’>

    softEdge

    Values must be of type <class ‘openpyxl.drawing.effect.SoftEdgesEffect’>

    class openpyxl.drawing.effect. FillOverlayEffect ( blend=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    blend

    Value must be one of {‘mult’, ‘over’, ‘lighten’, ‘darken’, ‘screen’}

    class openpyxl.drawing.effect. GlowEffect ( rad=None , **kw ) [source]

    Bases: openpyxl.drawing.colors.ColorChoice

    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’}

    rad

    Values must be of type <class ‘float’>

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

    class openpyxl.drawing.effect. GrayscaleEffect [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    tagname = 'grayscl'
    class openpyxl.drawing.effect. HSLEffect ( 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 ‘int’>

    sat

    Values must be of type <class ‘int’>

    class openpyxl.drawing.effect. InnerShadowEffect ( blurRad=None , dist=None , dir=None , **kw ) [source]

    Bases: openpyxl.drawing.colors.ColorChoice

    blurRad

    Values must be of type <class ‘float’>

    dir

    Values must be of type <class ‘int’>

    dist

    Values must be of type <class ‘float’>

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

    class openpyxl.drawing.effect. LuminanceEffect ( bright=0 , contrast=0 ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    bright

    Values must be of type <class ‘int’>

    contrast

    Values must be of type <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 ) [source]

    Bases: openpyxl.drawing.colors.ColorChoice

    algn

    Value must be one of {‘l’, ‘br’, ‘bl’, ‘r’, ‘t’, ‘tl’, ‘b’, ‘ctr’, ‘tr’}

    blurRad

    Values must be of type <class ‘float’>

    dir

    Values must be of type <class ‘int’>

    dist

    Values must be of type <class ‘float’>

    hslClr

    Values must be of type <class ‘openpyxl.drawing.colors.HSLColor’>

    kx

    Values must be of type <class ‘int’>

    ky

    Values must be of type <class ‘int’>

    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’}

    rotWithShape

    Values must be of type <class ‘bool’>

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

    sx

    Values must be of type <class ‘int’>

    sy

    Values must be of type <class ‘int’>

    sysClr

    Values must be of type <class ‘openpyxl.drawing.colors.SystemColor’>

    tagname = 'outerShdw'
    class openpyxl.drawing.effect. PresetShadowEffect ( prst=None , dist=None , dir=None , **kw ) [source]

    Bases: openpyxl.drawing.colors.ColorChoice

    dir

    Values must be of type <class ‘int’>

    dist

    Values must be of type <class ‘float’>

    hslClr

    Values must be of type <class ‘openpyxl.drawing.colors.HSLColor’>

    prst

    Value must be one of {‘shdw20’, ‘shdw16’, ‘shdw11’, ‘shdw17’, ‘shdw4’, ‘shdw7’, ‘shdw1’, ‘shdw13’, ‘shdw3’, ‘shdw14’, ‘shdw5’, ‘shdw18’, ‘shdw2’, ‘shdw15’, ‘shdw12’, ‘shdw19’, ‘shdw6’, ‘shdw9’, ‘shdw10’, ‘shdw8’}

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

    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 ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    algn

    Value must be one of {‘l’, ‘br’, ‘bl’, ‘r’, ‘t’, ‘tl’, ‘b’, ‘ctr’, ‘tr’}

    blurRad

    Values must be of type <class ‘float’>

    dir

    Values must be of type <class ‘int’>

    dist

    Values must be of type <class ‘float’>

    endA

    Values must be of type <class ‘int’>

    endPos

    Values must be of type <class ‘int’>

    fadeDir

    Values must be of type <class ‘int’>

    kx

    Values must be of type <class ‘int’>

    ky

    Values must be of type <class ‘int’>

    rotWithShape

    Values must be of type <class ‘bool’>

    stA

    Values must be of type <class ‘int’>

    stPos

    Values must be of type <class ‘int’>

    sx

    Values must be of type <class ‘int’>

    sy

    Values must be of type <class ‘int’>

    class openpyxl.drawing.effect. SoftEdgesEffect ( rad=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    rad

    Values must be of type <class ‘float’>

    class openpyxl.drawing.effect. TintEffect ( hue=0 , amt=0 ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    amt

    Values must be of type <class ‘int’>

    hue

    Values must be of type <class ‘int’>

    tagname = 'tint'