openpyxl.chart.axis module¶
- class openpyxl.chart.axis.ChartLines(spPr=None)[源代码]¶
基类：
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)[源代码]¶
基类：
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’, ‘r’, ‘t’, ‘b’}
- 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 {‘in’, ‘out’, ‘cross’}
- 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 {‘in’, ‘out’, ‘cross’}
- 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 {‘nextTo’, ‘high’, ‘low’}
- 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)[源代码]¶
基类：
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)[源代码]¶
基类：
openpyxl.descriptors.serialisable.Serialisable- builtInUnit¶
Value must be one of {‘hundredThousands’, ‘hundredMillions’, ‘hundreds’, ‘millions’, ‘billions’, ‘tenMillions’, ‘thousands’, ‘tenThousands’, ‘trillions’}
- 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)[源代码]¶
基类：
openpyxl.chart.axis._BaseAxis- axId¶
Values must be of type <class ‘int’>
- axPos¶
Value must be one of {‘l’, ‘r’, ‘t’, ‘b’}
- crossAx¶
Values must be of type <class ‘int’>
- crossBetween¶
Value must be one of {‘between’, ‘midCat’}
- 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’>
- majorGridlines¶
Values must be of type <class ‘openpyxl.chart.axis.ChartLines’>
- majorTickMark¶
Value must be one of {‘in’, ‘out’, ‘cross’}
- 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 {‘in’, ‘out’, ‘cross’}
- 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 {‘nextTo’, ‘high’, ‘low’}
- 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)[源代码]¶
基类：
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 {‘minMax’, ‘maxMin’}
- tagname = 'scaling'¶
- class openpyxl.chart.axis.SeriesAxis(tickLblSkip=None, tickMarkSkip=None, extLst=None, **kw)[源代码]¶
基类：
openpyxl.chart.axis._BaseAxis- axId¶
Values must be of type <class ‘int’>
- axPos¶
Value must be one of {‘l’, ‘r’, ‘t’, ‘b’}
- 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 {‘in’, ‘out’, ‘cross’}
- minorGridlines¶
Values must be of type <class ‘openpyxl.chart.axis.ChartLines’>
- minorTickMark¶
Value must be one of {‘in’, ‘out’, ‘cross’}
- 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 {‘nextTo’, ‘high’, ‘low’}
- 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)[源代码]¶
基类：
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’, ‘r’, ‘t’, ‘b’}
- 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’, ‘ctr’, ‘r’}
- 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 {‘in’, ‘out’, ‘cross’}
- minorGridlines¶
Values must be of type <class ‘openpyxl.chart.axis.ChartLines’>
- minorTickMark¶
Value must be one of {‘in’, ‘out’, ‘cross’}
- 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 {‘nextTo’, ‘high’, ‘low’}
- 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’>
