OpenPyXL 3.0.7

教程

简单用法

性能

优化模式

插入和删除行和列，移动单元格范围

操纵 Pandas 和 NumPy

图表

注释

操控样式

额外工作表特性

条件格式化

数据透视表

打印设置

使用过滤器和排序

验证单元格

定义名称

工作表表格

剖析公式

日期和时间

保护

开发

openpyxl 包

• 子包
  • openpyxl.cell 包
  • openpyxl.chart 包
    • 子模块
  • openpyxl.chartsheet 包
  • openpyxl.comments 包
  • openpyxl.descriptors 包
  • openpyxl.drawing 包
  • openpyxl.formatting 包
  • openpyxl.packaging 包
  • openpyxl.pivot 包
  • openpyxl.reader 包
  • openpyxl.styles 包
  • openpyxl.utils 包
  • openpyxl.workbook 包
  • openpyxl.worksheet 包
  • openpyxl.writer 包
  • openpyxl.xml 包

3.0.7 (2021-03-09)

3.0.6 (2021-01-14)

3.0.5 (2020-08-21)

3.0.4 (2020-06-24)

3.0.3 (2020-01-20)

3.0.2 (2019-11-25)

3.0.1 (2019-11-14)

3.0.0 (2019-09-25)

2.6.4 (2019-09-25)

2.6.3 (2019-08-19)

2.6.2 (2019-03-29)

2.6.1 (2019-03-04)

2.6.0 (2019-02-06)

2.6.-b1 (2019-01-08)

2.6-a1 (2018-11-21)

2.5.14 (2019-01-23)

2.5.13 (brown bag)

2.5.12 (2018-11-29)

2.5.11 (2018-11-21)

2.5.10 (2018-11-13)

2.5.9 (2018-10-19)

2.5.8 (2018-09-25)

2.5.7 (2018-09-13)

2.5.6 (2018-08-30)

2.5.5 (2018-08-04)

2.5.4 (2018-06-07)

2.5.3 (2018-04-18)

2.5.2 (2018-04-06)

2.5.1 (2018-03-12)

2.5.0 (2018-01-24)

2.5.0-b2 (2018-01-19)

2.5.0-b1 (2017-10-19)

2.5.0-a3 (2017-08-14)

2.5.0-a2 (2017-06-25)

2.5.0-a1 (2017-05-30)

2.4.11 (2018-01-24)

2.4.10 (2018-01-19)

2.4.9 (2017-10-19)

2.4.8 (2017-05-30)

2.4.7 (2017-04-24)

2.4.6 (2017-04-14)

2.4.5 (2017-03-07)

2.4.4 (2017-02-23)

2.4.3 (未发行)

2.4.2 (2017-01-31)

2.4.1 (2016-11-23)

2.4.0 (2016-09-15)

2.4.0-b1 (2016-06-08)

2.4.0-a1 (2016-04-11)

2.3.5 (2016-04-11)

2.3.4 (2016-03-16)

2.3.3 (2016-01-18)

2.3.2 (2015-12-07)

2.3.1 (2015-11-20)

2.3.0 (2015-10-20)

2.3.0-b2 (2015-09-04)

2.3.0-b1 (2015-06-29)

2.2.6 (未发行)

2.2.5 (2015-06-29)

2.2.4 (2015-06-17)

2.2.3 (2015-05-26)

2.2.2 (2015-04-28)

2.2.1 (2015-03-31)

2.2.0 (2015-03-11)

2.2.0-b1 (2015-02-18)

2.1.5 (2015-02-18)

2.1.4 (2014-12-16)

2.1.3 (2014-12-09)

2.1.2 (2014-10-23)

2.1.1 (2014-10-08)

2.1.0 (2014-09-21)

2.0.5 (2014-08-08)

2.0.4 (2014-06-25)

2.0.3 (2014-05-22)

2.0.2 (2014-05-13)

2.0.1 (2014-05-13) brown bag

2.0.0 (2014-05-13) brown bag

1.8.6 (2014-05-05)

1.8.5 (2014-03-25)

1.8.4 (2014-02-25)

1.8.3 (2014-02-09)

1.8.2 (2014-01-17)

1.8.1 (2014-01-14)

1.8.0 (2014-01-08)

1.7.0 (2013-10-31)

1. 首页
2. OpenPyXL 3.0.7
3. openpyxl 包
4. openpyxl.chart 包
5. openpyxl.chart.series 模块

openpyxl.chart.series 模块 ¶

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 ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

Generic 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’, ‘pyramidToMax’, ‘coneToMax’, ‘cylinder’, ‘box’, ‘cone’}

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”)

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

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 ) [source] ¶

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

值 ¶

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 ) [source] ¶

Bases: openpyxl.chart.series.Series

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