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:
openpyxl.descriptors.serialisable.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 descriptve 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 {‘movingAvg’, ‘poly’, ‘exp’, ‘power’, ‘log’, ‘linear’}
-
-
class
openpyxl.chart.trendline.
TrendlineLabel
(layout=None, tx=None, numFmt=None, spPr=None, txPr=None, extLst=None)[source]¶ Bases:
openpyxl.descriptors.serialisable.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 descriptve 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 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’>
-