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]
¶
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’>
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]
¶
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’>
autoUpdate
¶
Values must be of type <class ‘bool’>
id
¶
Values must be of type <class ‘str’>
tagname
= 'externalData'
¶
openpyxl.chart.chartspace.
保护
(
chartObject=None
,
data=None
,
formatting=None
,
selection=None
,
userInterface=None
)
[source]
¶
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’>