openpyxl.chart.trendline module
- class openpyxl.chart.trendline.Trendline(name=None, spPr=None, trendlineType='linear', order=None, period=None, forward=None, backward=None, intercept=None, dispRSqr=None, dispEq=None, trendlineLbl=None, extLst=None)[source]
Bases:
Serialisable- backward
Values must be of type <class ‘float’>
- dispEq
Values must be of type <class ‘bool’>
- dispRSqr
Values must be of type <class ‘bool’>
- extLst
Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>
- forward
Values must be of type <class ‘float’>
- graphicalProperties
Aliases can be used when either the desired attribute name is not allowed or confusing in Python (eg. “type”) or a more descriptive name is desired (eg. “underline” for “u”)
- intercept
Values must be of type <class ‘float’>
- name
Values must be of type <class ‘str’>
- order
Values must be of type <class ‘int’>
- period
Values must be of type <class ‘int’>
- spPr
Values must be of type <class ‘openpyxl.chart.shapes.GraphicalProperties’>
- tagname = 'trendline'
- trendlineLbl
Values must be of type <class ‘openpyxl.chart.trendline.TrendlineLabel’>
- trendlineType
Value must be one of {‘linear’, ‘power’, ‘poly’, ‘log’, ‘movingAvg’, ‘exp’}
- class openpyxl.chart.trendline.TrendlineLabel(layout=None, tx=None, numFmt=None, spPr=None, txPr=None, extLst=None)[source]
Bases:
Serialisable- extLst
Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>
- graphicalProperties
Aliases can be used when either the desired attribute name is not allowed or confusing in Python (eg. “type”) or a more descriptive name is desired (eg. “underline” for “u”)
- layout
Values must be of type <class ‘openpyxl.chart.layout.Layout’>
- numFmt
Values must be of type <class ‘openpyxl.chart.data_source.NumFmt’>
- spPr
Values must be of type <class ‘openpyxl.chart.shapes.GraphicalProperties’>
- tagname = 'trendlineLbl'
- textProperties
Aliases can be used when either the desired attribute name is not allowed or confusing in Python (eg. “type”) or a more descriptive 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’>
