openpyxl.chart.chartspace module¶

Enclosing chart object. The various chart types are actually child objects. Will probably need to call this indirectly

class openpyxl.chart.chartspace.ChartContainer(title=None, autoTitleDeleted=None, pivotFmts=(), view3D=None, floor=None, sideWall=None, backWall=None, plotArea=None, legend=None, plotVisOnly=True, 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 {‘gap’, ‘zero’, ‘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¶: Wrap a sequence in an containing object

plotArea¶: Values must be of type <class ‘openpyxl.chart.plotarea.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’>

graphical_properties¶: 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”)

lang¶: Values must be of type <class ‘str’>

pivotSource¶: Values must be of type <class ‘openpyxl.chart.pivot.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 descriptive name is desired (eg. “underline” for “u”)

to_tree(tagname=None, idx=None, namespace=None)[source]¶

txPr¶: Values must be of type <class ‘openpyxl.chart.text.RichText’>

userShapes¶: Values must be of type <class ‘str’>

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.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’>