openpyxl.chart.pivot module¶
-
class
openpyxl.chart.pivot.
PivotFormat
(idx=0, spPr=None, txPr=None, marker=None, dLbl=None, extLst=None)[source]¶ Bases:
openpyxl.descriptors.serialisable.Serialisable
-
DataLabel
¶ 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”)
-
TextBody
¶ 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”)
-
dLbl
¶ Values must be of type <class ‘openpyxl.chart.label.DataLabel’>
-
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”)
-
idx
¶ Values must be of type <class ‘int’>
-
marker
¶ Values must be of type <class ‘openpyxl.chart.marker.Marker’>
-
spPr
¶ Values must be of type <class ‘openpyxl.chart.shapes.GraphicalProperties’>
-
tagname
= 'pivotFmt'¶
-
txPr
¶ Values must be of type <class ‘openpyxl.chart.text.RichText’>
-
-
class
openpyxl.chart.pivot.
PivotSource
(name=None, fmtId=None, extLst=None)[source]¶ Bases:
openpyxl.descriptors.serialisable.Serialisable
-
extLst
¶ Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>
-
fmtId
¶ Values must be of type <class ‘int’>
-
name
¶ Values must be of type <class ‘str’>
-
tagname
= 'pivotSource'¶
-