就业培训     下载中心     Wiki     联络
登录   注册
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)
    1. 首页
    2. OpenPyXL 3.0.7
    3. openpyxl 包
    4. openpyxl.chart 包
    5. openpyxl.chart.axis 模块

    openpyxl.chart.axis 模块

    class openpyxl.chart.axis. ChartLines ( spPr=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    graphicalProperties

    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”)

    spPr

    Values must be of type <class ‘openpyxl.chart.shapes.GraphicalProperties’>

    tagname = 'chartLines'
    class openpyxl.chart.axis. DateAxis ( auto=None , lblOffset=None , baseTimeUnit=None , majorUnit=None , majorTimeUnit=None , minorUnit=None , minorTimeUnit=None , extLst=None , **kw ) [source]

    Bases: openpyxl.chart.axis.TextAxis

    auto

    Values must be of type <class ‘bool’>

    axId

    Values must be of type <class ‘int’>

    axPos

    Value must be one of {‘l’, ‘b’, ‘r’, ‘t’}

    baseTimeUnit

    Value must be one of {‘years’, ‘days’, ‘months’}

    crossAx

    Values must be of type <class ‘int’>

    crosses

    Value must be one of {‘max’, ‘min’, ‘autoZero’}

    crossesAt

    Values must be of type <class ‘float’>

    delete

    Values must be of type <class ‘bool’>

    extLst

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

    lblOffset

    Values must be of type <class ‘int’>

    majorGridlines

    Values must be of type <class ‘openpyxl.chart.axis.ChartLines’>

    majorTickMark

    Value must be one of {‘out’, ‘cross’, ‘in’}

    majorTimeUnit

    Value must be one of {‘years’, ‘days’, ‘months’}

    majorUnit

    Values must be of type <class ‘float’>

    minorGridlines

    Values must be of type <class ‘openpyxl.chart.axis.ChartLines’>

    minorTickMark

    Value must be one of {‘out’, ‘cross’, ‘in’}

    minorTimeUnit

    Value must be one of {‘years’, ‘days’, ‘months’}

    minorUnit

    Values must be of type <class ‘float’>

    numFmt

    Values must be of type <class ‘openpyxl.chart.data_source.NumFmt’>

    scaling

    Values must be of type <class ‘openpyxl.chart.axis.Scaling’>

    spPr

    Values must be of type <class ‘openpyxl.chart.shapes.GraphicalProperties’>

    tagname = 'dateAx'
    tickLblPos

    Value must be one of {‘low’, ‘nextTo’, ‘high’}

    title

    Values must be of type <class ‘openpyxl.chart.title.Title’>

    txPr

    Values must be of type <class ‘openpyxl.chart.text.RichText’>

    class openpyxl.chart.axis. DisplayUnitsLabel ( layout=None , tx=None , spPr=None , txPr=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    graphicalProperties

    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”)

    layout

    Values must be of type <class ‘openpyxl.chart.layout.Layout’>

    spPr

    Values must be of type <class ‘openpyxl.chart.shapes.GraphicalProperties’>

    tagname = 'dispUnitsLbl'
    text

    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”)

    textPropertes

    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”)

    tx

    Values must be of type <class ‘openpyxl.chart.text.Text’>

    txPr

    Values must be of type <class ‘openpyxl.chart.text.RichText’>

    class openpyxl.chart.axis. DisplayUnitsLabelList ( custUnit=None , builtInUnit=None , dispUnitsLbl=None , extLst=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    builtInUnit

    Value must be one of {‘hundreds’, ‘hundredMillions’, ‘trillions’, ‘hundredThousands’, ‘tenThousands’, ‘billions’, ‘millions’, ‘tenMillions’, ‘thousands’}

    custUnit

    Values must be of type <class ‘float’>

    dispUnitsLbl

    Values must be of type <class ‘openpyxl.chart.axis.DisplayUnitsLabel’>

    extLst

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

    tagname = 'dispUnits'
    class openpyxl.chart.axis. NumericAxis ( crossBetween=None , majorUnit=None , minorUnit=None , dispUnits=None , extLst=None , **kw ) [source]

    Bases: openpyxl.chart.axis._BaseAxis

    axId

    Values must be of type <class ‘int’>

    axPos

    Value must be one of {‘l’, ‘b’, ‘r’, ‘t’}

    crossAx

    Values must be of type <class ‘int’>

    crossBetween

    Value must be one of {‘midCat’, ‘between’}

    crosses

    Value must be one of {‘max’, ‘min’, ‘autoZero’}

    crossesAt

    Values must be of type <class ‘float’>

    delete

    Values must be of type <class ‘bool’>

    dispUnits

    Values must be of type <class ‘openpyxl.chart.axis.DisplayUnitsLabelList’>

    extLst

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

    classmethod from_tree ( node ) [source]

    Special case value axes with no gridlines

    majorGridlines

    Values must be of type <class ‘openpyxl.chart.axis.ChartLines’>

    majorTickMark

    Value must be one of {‘out’, ‘cross’, ‘in’}

    majorUnit

    Values must be of type <class ‘float’>

    minorGridlines

    Values must be of type <class ‘openpyxl.chart.axis.ChartLines’>

    minorTickMark

    Value must be one of {‘out’, ‘cross’, ‘in’}

    minorUnit

    Values must be of type <class ‘float’>

    numFmt

    Values must be of type <class ‘openpyxl.chart.data_source.NumFmt’>

    scaling

    Values must be of type <class ‘openpyxl.chart.axis.Scaling’>

    spPr

    Values must be of type <class ‘openpyxl.chart.shapes.GraphicalProperties’>

    tagname = 'valAx'
    tickLblPos

    Value must be one of {‘low’, ‘nextTo’, ‘high’}

    title

    Values must be of type <class ‘openpyxl.chart.title.Title’>

    txPr

    Values must be of type <class ‘openpyxl.chart.text.RichText’>

    class openpyxl.chart.axis. Scaling ( logBase=None , orientation='minMax' , max=None , min=None , extLst=None ) [source]

    Bases: openpyxl.descriptors.serialisable.Serialisable

    extLst

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

    logBase

    Values must be of type <class ‘float’>

    max

    Values must be of type <class ‘float’>

    min

    Values must be of type <class ‘float’>

    orientation

    Value must be one of {‘maxMin’, ‘minMax’}

    tagname = 'scaling'
    class openpyxl.chart.axis. SeriesAxis ( tickLblSkip=None , tickMarkSkip=None , extLst=None , **kw ) [source]

    Bases: openpyxl.chart.axis._BaseAxis

    axId

    Values must be of type <class ‘int’>

    axPos

    Value must be one of {‘l’, ‘b’, ‘r’, ‘t’}

    crossAx

    Values must be of type <class ‘int’>

    crosses

    Value must be one of {‘max’, ‘min’, ‘autoZero’}

    crossesAt

    Values must be of type <class ‘float’>

    delete

    Values must be of type <class ‘bool’>

    extLst

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

    majorGridlines

    Values must be of type <class ‘openpyxl.chart.axis.ChartLines’>

    majorTickMark

    Value must be one of {‘out’, ‘cross’, ‘in’}

    minorGridlines

    Values must be of type <class ‘openpyxl.chart.axis.ChartLines’>

    minorTickMark

    Value must be one of {‘out’, ‘cross’, ‘in’}

    numFmt

    Values must be of type <class ‘openpyxl.chart.data_source.NumFmt’>

    scaling

    Values must be of type <class ‘openpyxl.chart.axis.Scaling’>

    spPr

    Values must be of type <class ‘openpyxl.chart.shapes.GraphicalProperties’>

    tagname = 'serAx'
    tickLblPos

    Value must be one of {‘low’, ‘nextTo’, ‘high’}

    tickLblSkip

    Values must be of type <class ‘int’>

    tickMarkSkip

    Values must be of type <class ‘int’>

    title

    Values must be of type <class ‘openpyxl.chart.title.Title’>

    txPr

    Values must be of type <class ‘openpyxl.chart.text.RichText’>

    class openpyxl.chart.axis. TextAxis ( auto=None , lblAlgn=None , lblOffset=100 , tickLblSkip=None , tickMarkSkip=None , noMultiLvlLbl=None , extLst=None , **kw ) [source]

    Bases: openpyxl.chart.axis._BaseAxis

    auto

    Values must be of type <class ‘bool’>

    axId

    Values must be of type <class ‘int’>

    axPos

    Value must be one of {‘l’, ‘b’, ‘r’, ‘t’}

    crossAx

    Values must be of type <class ‘int’>

    crosses

    Value must be one of {‘max’, ‘min’, ‘autoZero’}

    crossesAt

    Values must be of type <class ‘float’>

    delete

    Values must be of type <class ‘bool’>

    extLst

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

    lblAlgn

    Value must be one of {‘l’, ‘r’, ‘ctr’}

    lblOffset

    Values must be of type <class ‘float’>

    majorGridlines

    Values must be of type <class ‘openpyxl.chart.axis.ChartLines’>

    majorTickMark

    Value must be one of {‘out’, ‘cross’, ‘in’}

    minorGridlines

    Values must be of type <class ‘openpyxl.chart.axis.ChartLines’>

    minorTickMark

    Value must be one of {‘out’, ‘cross’, ‘in’}

    noMultiLvlLbl

    Values must be of type <class ‘bool’>

    numFmt

    Values must be of type <class ‘openpyxl.chart.data_source.NumFmt’>

    scaling

    Values must be of type <class ‘openpyxl.chart.axis.Scaling’>

    spPr

    Values must be of type <class ‘openpyxl.chart.shapes.GraphicalProperties’>

    tagname = 'catAx'
    tickLblPos

    Value must be one of {‘low’, ‘nextTo’, ‘high’}

    tickLblSkip

    Values must be of type <class ‘int’>

    tickMarkSkip

    Values must be of type <class ‘int’>

    title

    Values must be of type <class ‘openpyxl.chart.title.Title’>

    txPr

    Values must be of type <class ‘openpyxl.chart.text.RichText’>

    1. 首页
    2. OpenPyXL 3.0.7