openpyxl.chart.plotarea module¶
-
class
openpyxl.chart.plotarea.
DataTable
(showHorzBorder=None, showVertBorder=None, showOutline=None, showKeys=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 descriptive name is desired (eg. “underline” for “u”)
-
showHorzBorder
¶ Values must be of type <class ‘bool’>
-
showKeys
¶ Values must be of type <class ‘bool’>
-
showOutline
¶ Values must be of type <class ‘bool’>
-
showVertBorder
¶ Values must be of type <class ‘bool’>
-
spPr
¶ Values must be of type <class ‘openpyxl.chart.shapes.GraphicalProperties’>
-
tagname
= 'dTable'¶
-
txPr
¶ Values must be of type <class ‘openpyxl.chart.text.RichText’>
-
-
class
openpyxl.chart.plotarea.
PlotArea
(layout=None, dTable=None, spPr=None, _charts=(), _axes=(), extLst=None)[source]¶ Bases:
openpyxl.descriptors.serialisable.Serialisable
-
area3DChart
¶ Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
-
areaChart
¶ Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
-
bar3DChart
¶ Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
-
barChart
¶ Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
-
bubbleChart
¶ Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
-
catAx
¶ Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
-
dTable
¶ Values must be of type <class ‘openpyxl.chart.plotarea.DataTable’>
-
dateAx
¶ Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
-
doughnutChart
¶ Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
-
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’>
-
line3DChart
¶ Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
-
lineChart
¶ Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
-
ofPieChart
¶ Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
-
pie3DChart
¶ Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
-
pieChart
¶ Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
-
radarChart
¶ Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
-
scatterChart
¶ Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
-
serAx
¶ Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
-
spPr
¶ Values must be of type <class ‘openpyxl.chart.shapes.GraphicalProperties’>
-
stockChart
¶ Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
-
surface3DChart
¶ Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
-
surfaceChart
¶ Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
-
tagname
= 'plotArea'¶
-
valAx
¶ Allow a multisequence to be built up from parts
Excluded from the instance __elements__ or __attrs__ as is effectively an Alias
-