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)

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)

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)

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)

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)

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=())

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)

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)

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'

to_tree(tagname=None, idx=None)

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)

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