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)[源代码]¶
基类：
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 {‘span’, ‘zero’, ‘gap’}
- 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)[源代码]¶
基类：
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.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 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.ExternalData(autoUpdate=None, id=None)[源代码]¶
基类：
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)[源代码]¶
基类：
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’>
