openpyxl.chart.chartspace module¶
-
class
openpyxl.chart.chartspace.
ChartContainer
(title=None, autoTitleDeleted=None, pivotFmts=None, view3D=None, floor=None, sideWall=None, backWall=None, plotArea=None, legend=None, plotVisOnly=None, dispBlanksAs='gap', showDLblsOverMax=None, extLst=None)[source]¶ Bases:
openpyxl.descriptors.serialisable.Serialisable
-
autoTitleDeleted
¶ Values must be of type <class ‘bool’>
-
backWall
¶ Values must be of type <class ‘openpyxl.chart._3d.Surface’>
-
dispBlanksAs
¶ Value must be one of {‘zero’, ‘gap’, ‘span’}
-
extLst
¶ Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>
-
floor
¶ Values must be of type <class ‘openpyxl.chart._3d.Surface’>
-
legend
¶ Values must be of type <class ‘openpyxl.chart.legend.Legend’>
-
pivotFmts
¶ Values must be of type <class ‘openpyxl.chart.chartspace.PivotFormatList’>
-
plotArea
¶ Values must be of type <class ‘openpyxl.chart.chartspace.PlotArea’>
-
plotVisOnly
¶ Values must be of type <class ‘bool’>
-
showDLblsOverMax
¶ Values must be of type <class ‘bool’>
-
sideWall
¶ Values must be of type <class ‘openpyxl.chart._3d.Surface’>
-
tagname
= 'chart'¶
-
title
¶ Values must be of type <class ‘openpyxl.chart.title.Title’>
-
view3D
¶ Values must be of type <class ‘openpyxl.chart._3d.View3D’>
-
-
class
openpyxl.chart.chartspace.
ChartSpace
(date1904=None, lang=None, roundedCorners=None, style=None, clrMapOvr=None, pivotSource=None, protection=None, chart=None, spPr=None, txPr=None, externalData=None, printSettings=None, userShapes=None, extLst=None)[source]¶ Bases:
openpyxl.descriptors.serialisable.Serialisable
-
chart
¶ Values must be of type <class ‘openpyxl.chart.chartspace.ChartContainer’>
-
clrMapOvr
¶ Values must be of type <class ‘openpyxl.drawing.colors.ColorMapping’>
-
date1904
¶ Values must be of type <class ‘bool’>
-
extLst
¶ Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>
-
externalData
¶ Values must be of type <class ‘openpyxl.chart.chartspace.ExternalData’>
-
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”)
-
lang
¶ Values must be of type <class ‘str’>
-
pivotSource
¶ Values must be of type <class ‘openpyxl.chart.chartspace.PivotSource’>
-
printSettings
¶ Values must be of type <class ‘openpyxl.chart.print_settings.PrintSettings’>
-
protection
¶ Values must be of type <class ‘openpyxl.chart.chartspace.Protection’>
-
roundedCorners
¶ Values must be of type <class ‘bool’>
-
spPr
¶ Values must be of type <class ‘openpyxl.chart.shapes.GraphicalProperties’>
-
style
¶ Values must be of type <class ‘float’>
-
tagname
= 'chartSpace'¶
-
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”)
-
txPr
¶ Values must be of type <class ‘openpyxl.chart.text.RichText’>
-
userShapes
¶ Values must be of type <class ‘str’>
-
-
class
openpyxl.chart.chartspace.
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 descriptve 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.chartspace.
ExternalData
(autoUpdate=None, id=None)[source]¶ Bases:
openpyxl.descriptors.serialisable.Serialisable
-
autoUpdate
¶ Values must be of type <class ‘bool’>
-
id
¶ Values must be of type <class ‘str’>
-
tagname
= 'externalData'¶
-
-
class
openpyxl.chart.chartspace.
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 descriptve 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 descriptve 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 descriptve 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.chartspace.
PivotFormatList
(pivotFmt=())[source]¶ Bases:
openpyxl.descriptors.serialisable.Serialisable
-
pivotFmt
¶ A sequence (list or tuple) that may only contain objects of the declared type
-
tagname
= 'pivotFmts'¶
-
-
class
openpyxl.chart.chartspace.
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'¶
-
-
class
openpyxl.chart.chartspace.
PlotArea
(layout=None, dTable=None, spPr=None, areaChart=None, area3DChart=None, lineChart=None, line3DChart=None, stockChart=None, radarChart=None, scatterChart=None, pieChart=None, pie3DChart=None, doughnutChart=None, barChart=None, bar3DChart=None, ofPieChart=None, surfaceChart=None, surface3DChart=None, bubbleChart=None, valAx=(), catAx=(), serAx=(), dateAx=(), extLst=None)[source]¶ Bases:
openpyxl.descriptors.serialisable.Serialisable
-
area3DChart
¶ Values must be of type <class ‘openpyxl.chart.area_chart.AreaChart3D’>
-
areaChart
¶ Values must be of type <class ‘openpyxl.chart.area_chart.AreaChart’>
-
bar3DChart
¶ Values must be of type <class ‘openpyxl.chart.bar_chart.BarChart3D’>
-
barChart
¶ Values must be of type <class ‘openpyxl.chart.bar_chart.BarChart’>
-
bubbleChart
¶ Values must be of type <class ‘openpyxl.chart.bubble_chart.BubbleChart’>
-
catAx
¶ A sequence (list or tuple) that may only contain objects of the declared type
-
dTable
¶ Values must be of type <class ‘openpyxl.chart.chartspace.DataTable’>
-
dateAx
¶ A sequence (list or tuple) that may only contain objects of the declared type
-
doughnutChart
¶ Values must be of type <class ‘openpyxl.chart.pie_chart.DoughnutChart’>
-
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’>
-
line3DChart
¶ Values must be of type <class ‘openpyxl.chart.line_chart.LineChart3D’>
-
lineChart
¶ Values must be of type <class ‘openpyxl.chart.line_chart.LineChart’>
-
ofPieChart
¶ Values must be of type <class ‘openpyxl.chart.pie_chart.ProjectedPieChart’>
-
pie3DChart
¶ Values must be of type <class ‘openpyxl.chart.pie_chart.PieChart3D’>
-
pieChart
¶ Values must be of type <class ‘openpyxl.chart.pie_chart.PieChart’>
-
radarChart
¶ Values must be of type <class ‘openpyxl.chart.radar_chart.RadarChart’>
-
scatterChart
¶ Values must be of type <class ‘openpyxl.chart.scatter_chart.ScatterChart’>
-
serAx
¶ A sequence (list or tuple) that may only contain objects of the declared type
-
spPr
¶ Values must be of type <class ‘openpyxl.chart.shapes.GraphicalProperties’>
-
stockChart
¶ Values must be of type <class ‘openpyxl.chart.stock_chart.StockChart’>
-
surface3DChart
¶ Values must be of type <class ‘openpyxl.chart.surface_chart.SurfaceChart3D’>
-
surfaceChart
¶ Values must be of type <class ‘openpyxl.chart.surface_chart.SurfaceChart’>
-
tagname
= 'plotArea'¶
-
valAx
¶ A sequence (list or tuple) that may only contain objects of the declared type
-
-
class
openpyxl.chart.chartspace.
Protection
(chartObject=None, data=None, formatting=None, selection=None, userInterface=None)[source]¶ Bases:
openpyxl.descriptors.serialisable.Serialisable
-
chartObject
¶ Values must be of type <class ‘bool’>
-
data
¶ Values must be of type <class ‘bool’>
-
formatting
¶ Values must be of type <class ‘bool’>
-
selection
¶ Values must be of type <class ‘bool’>
-
tagname
= 'protection'¶
-
userInterface
¶ Values must be of type <class ‘bool’>
-