openpyxl.chart.series module¶
- class openpyxl.chart.series.Series(idx=0, order=0, tx=None, spPr=None, pictureOptions=None, dPt=(), dLbls=None, trendline=None, errBars=None, cat=None, val=None, invertIfNegative=None, shape=None, xVal=None, yVal=None, bubbleSize=None, bubble3D=None, marker=None, smooth=None, explosion=None, extLst=None)[源代码]¶
基类：
openpyxl.descriptors.serialisable.SerialisableGeneric series object. Should not be instantiated directly. User the chart.Series factory instead.
- bubble3D¶
Values must be of type <class ‘bool’>
- bubbleSize¶
Values must be of type <class ‘openpyxl.chart.data_source.NumDataSource’>
- cat¶
Values must be of type <class ‘openpyxl.chart.data_source.AxDataSource’>
- dLbls¶
Values must be of type <class ‘openpyxl.chart.label.DataLabelList’>
- dPt¶
A sequence (list or tuple) that may only contain objects of the declared type
- data_points¶
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”)
- errBars¶
Values must be of type <class ‘openpyxl.chart.error_bar.ErrorBars’>
- explosion¶
Values must be of type <class ‘int’>
- 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”)
- identifiers¶
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’>
- invertIfNegative¶
Values must be of type <class ‘bool’>
- labels¶
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”)
- marker¶
Values must be of type <class ‘openpyxl.chart.marker.Marker’>
- order¶
Values must be of type <class ‘int’>
- pictureOptions¶
Values must be of type <class ‘openpyxl.chart.picture.PictureOptions’>
- shape¶
Value must be one of {‘pyramid’, ‘cylinder’, ‘cone’, ‘pyramidToMax’, ‘coneToMax’, ‘box’}
- smooth¶
Values must be of type <class ‘bool’>
- spPr¶
Values must be of type <class ‘openpyxl.chart.shapes.GraphicalProperties’>
- tagname = 'ser'¶
- title¶
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”)
- trendline¶
Values must be of type <class ‘openpyxl.chart.trendline.Trendline’>
- tx¶
Values must be of type <class ‘openpyxl.chart.series.SeriesLabel’>
- val¶
Values must be of type <class ‘openpyxl.chart.data_source.NumDataSource’>
- xVal¶
Values must be of type <class ‘openpyxl.chart.data_source.AxDataSource’>
- yVal¶
Values must be of type <class ‘openpyxl.chart.data_source.NumDataSource’>
- zVal¶
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”)
- class openpyxl.chart.series.SeriesLabel(strRef=None, v=None)[源代码]¶
基类：
openpyxl.descriptors.serialisable.Serialisable- strRef¶
Values must be of type <class ‘openpyxl.chart.data_source.StrRef’>
- tagname = 'tx'¶
- v¶
Values must be of type <class ‘str’>
- value¶
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”)
- class openpyxl.chart.series.XYSeries(idx=0, order=0, tx=None, spPr=None, pictureOptions=None, dPt=(), dLbls=None, trendline=None, errBars=None, cat=None, val=None, invertIfNegative=None, shape=None, xVal=None, yVal=None, bubbleSize=None, bubble3D=None, marker=None, smooth=None, explosion=None, extLst=None)[源代码]¶
基类：
openpyxl.chart.series.SeriesDedicated series for charts that have x and y series
- bubble3D¶
Values must be of type <class ‘bool’>
- bubbleSize¶
Values must be of type <class ‘openpyxl.chart.data_source.NumDataSource’>
- dLbls¶
Values must be of type <class ‘openpyxl.chart.label.DataLabelList’>
- dPt¶
A sequence (list or tuple) that may only contain objects of the declared type
- errBars¶
Values must be of type <class ‘openpyxl.chart.error_bar.ErrorBars’>
- idx¶
Values must be of type <class ‘int’>
- invertIfNegative¶
Values must be of type <class ‘bool’>
- marker¶
Values must be of type <class ‘openpyxl.chart.marker.Marker’>
- order¶
Values must be of type <class ‘int’>
- smooth¶
Values must be of type <class ‘bool’>
- spPr¶
Values must be of type <class ‘openpyxl.chart.shapes.GraphicalProperties’>
- trendline¶
Values must be of type <class ‘openpyxl.chart.trendline.Trendline’>
- tx¶
Values must be of type <class ‘openpyxl.chart.series.SeriesLabel’>
- xVal¶
Values must be of type <class ‘openpyxl.chart.data_source.AxDataSource’>
- yVal¶
Values must be of type <class ‘openpyxl.chart.data_source.NumDataSource’>
