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.pie_chart 模块

openpyxl.chart.pie_chart 模块 ¶

class openpyxl.chart.pie_chart. CustomSplit ( secondPiePt=() ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

secondPiePt ¶

A sequence of primitive types that are stored as a single attribute. “val” is the default attribute

tagname = 'custSplit' ¶

class openpyxl.chart.pie_chart. DoughnutChart ( firstSliceAng=0 , holeSize=10 , extLst=None , **kw ) [source] ¶

Bases: openpyxl.chart.pie_chart._PieChartBase

dLbls ¶

Values must be of type <class ‘openpyxl.chart.label.DataLabelList’>

extLst ¶

Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>

firstSliceAng ¶

Values must be of type <class ‘float’>

holeSize ¶

Values must be of type <class ‘float’>

ser ¶

A sequence (list or tuple) that may only contain objects of the declared type

tagname = 'doughnutChart' ¶

varyColors ¶

Values must be of type <class ‘bool’>

class openpyxl.chart.pie_chart. PieChart ( firstSliceAng=0 , extLst=None , **kw ) [source] ¶

Bases: openpyxl.chart.pie_chart._PieChartBase

dLbls ¶

Values must be of type <class ‘openpyxl.chart.label.DataLabelList’>

extLst ¶

Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>

firstSliceAng ¶

Values must be of type <class ‘float’>

ser ¶

A sequence (list or tuple) that may only contain objects of the declared type

tagname = 'pieChart' ¶

varyColors ¶

Values must be of type <class ‘bool’>

class openpyxl.chart.pie_chart. PieChart3D ( varyColors=True , ser=() , dLbls=None ) [source] ¶

Bases: openpyxl.chart.pie_chart._PieChartBase

dLbls ¶

Values must be of type <class ‘openpyxl.chart.label.DataLabelList’>

extLst ¶

Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>

ser ¶

A sequence (list or tuple) that may only contain objects of the declared type

tagname = 'pie3DChart' ¶

varyColors ¶

Values must be of type <class ‘bool’>

class openpyxl.chart.pie_chart. ProjectedPieChart ( ofPieType='pie' , gapWidth=None , splitType='auto' , splitPos=None , custSplit=None , secondPieSize=75 , serLines=None , extLst=None , **kw ) [source] ¶

Bases: openpyxl.chart.pie_chart._PieChartBase

From the spec 21.2.2.126

This element contains the pie of pie or bar of pie series on this chart. Only the first series shall be displayed. The splitType element shall determine whether the splitPos and custSplit elements apply.

custSplit ¶

Values must be of type <class ‘openpyxl.chart.pie_chart.CustomSplit’>

dLbls ¶

Values must be of type <class ‘openpyxl.chart.label.DataLabelList’>

extLst ¶

Values must be of type <class ‘openpyxl.descriptors.excel.ExtensionList’>

gapWidth ¶

Values must be of type <class ‘float’>

join_lines ¶

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

ofPieType ¶

Value must be one of {‘pie’, ‘bar’}

secondPieSize ¶

Values must be of type <class ‘float’>

ser ¶

A sequence (list or tuple) that may only contain objects of the declared type

serLines ¶

Values must be of type <class ‘openpyxl.chart.axis.ChartLines’>

splitPos ¶

Values must be of type <class ‘float’>

splitType ¶

Value must be one of {‘percent’, ‘cust’, ‘pos’, ‘auto’, ‘val’}

tagname = 'ofPieChart' ¶

type ¶

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

varyColors ¶

Values must be of type <class ‘bool’>