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.pivot 包
5. openpyxl.pivot.table 模块

openpyxl.pivot.table 模块 ¶

class openpyxl.pivot.table. AutoSortScope ( pivotArea=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

pivotArea ¶

Values must be of type <class ‘openpyxl.pivot.table.PivotArea’>

class openpyxl.pivot.table. ChartFormat ( chart=None , format=None , series=None , pivotArea=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

chart ¶

Values must be of type <class ‘int’>

format ¶

Values must be of type <class ‘int’>

pivotArea ¶

Values must be of type <class ‘openpyxl.pivot.table.PivotArea’>

series ¶

Values must be of type <class ‘bool’>

tagname = 'chartFormat' ¶

class openpyxl.pivot.table. ColHierarchiesUsage ( count=None , colHierarchyUsage=() ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

colHierarchyUsage ¶

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

count ¶

tagname = 'colHierarchiesUsage' ¶

class openpyxl.pivot.table. ConditionalFormat ( scope=None , type=None , priority=None , pivotAreas=() , extLst=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

extLst ¶

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

pivotAreas ¶

Wrap a sequence in an containing object

priority ¶

Values must be of type <class ‘int’>

scope ¶

Value must be one of {‘data’, ‘field’, ‘selection’}

tagname = 'conditionalFormat' ¶

type ¶

Value must be one of {‘column’, ‘all’, ‘row’}

class openpyxl.pivot.table. DataField ( name=None , fld=None , subtotal='sum' , showDataAs='normal' , baseField=-1 , baseItem=1048832 , numFmtId=None , extLst=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

baseField ¶

Values must be of type <class ‘int’>

baseItem ¶

Values must be of type <class ‘int’>

extLst ¶

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

fld ¶

Values must be of type <class ‘int’>

name ¶

Values must be of type <class ‘str’>

numFmtId ¶

Values must be of type <class ‘int’>

showDataAs ¶

Value must be one of {‘percent’, ‘index’, ‘percentOfCol’, ‘runTotal’, ‘percentOfRow’, ‘percentOfTotal’, ‘difference’, ‘percentDiff’, ‘normal’}

subtotal ¶

Value must be one of {‘count’, ‘stdDev’, ‘stdDevp’, ‘var’, ‘min’, ‘product’, ‘max’, ‘countNums’, ‘average’, ‘sum’, ‘varp’}

tagname = 'dataField' ¶

class openpyxl.pivot.table. FieldItem ( n=None , t='data' , h=None , s=None , sd=True , f=None , m=None , c=None , x=None , d=None , e=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

c ¶

Values must be of type <class ‘bool’>

d ¶

Values must be of type <class ‘bool’>

e ¶

Values must be of type <class ‘bool’>

f ¶

Values must be of type <class ‘bool’>

h ¶

Values must be of type <class ‘bool’>

m ¶

Values must be of type <class ‘bool’>

n ¶

Values must be of type <class ‘str’>

s ¶

Values must be of type <class ‘bool’>

sd ¶

Values must be of type <class ‘bool’>

t ¶

Value must be one of {‘data’, ‘default’, ‘countA’, ‘grand’, ‘stdDev’, ‘stdDevP’, ‘var’, ‘min’, ‘product’, ‘varP’, ‘max’, ‘avg’, ‘count’, ‘sum’, ‘blank’}

tagname = 'item' ¶

x ¶

Values must be of type <class ‘int’>

class openpyxl.pivot.table. 格式 ( action='formatting' , dxfId=None , pivotArea=None , extLst=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

action ¶

Value must be one of {‘formatting’, ‘drill’, ‘formula’, ‘blank’}

dxfId ¶

Values must be of type <class ‘int’>

extLst ¶

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

pivotArea ¶

Values must be of type <class ‘openpyxl.pivot.table.PivotArea’>

tagname = 'format' ¶

class openpyxl.pivot.table. HierarchyUsage ( hierarchyUsage=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

hierarchyUsage ¶

Values must be of type <class ‘int’>

tagname = 'hierarchyUsage' ¶

class openpyxl.pivot.table. 定位 ( ref=None , firstHeaderRow=None , firstDataRow=None , firstDataCol=None , rowPageCount=None , colPageCount=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

colPageCount ¶

Values must be of type <class ‘int’>

firstDataCol ¶

Values must be of type <class ‘int’>

firstDataRow ¶

Values must be of type <class ‘int’>

firstHeaderRow ¶

Values must be of type <class ‘int’>

ref ¶

Values must be of type <class ‘str’>

rowPageCount ¶

Values must be of type <class ‘int’>

tagname = 'location' ¶

class openpyxl.pivot.table. MemberList ( count=None , level=None , member=() ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

count ¶

level ¶

Values must be of type <class ‘int’>

member ¶

Wrap a sequence in an containing object

tagname = 'members' ¶

class openpyxl.pivot.table. MemberProperty ( name=None , showCell=None , showTip=None , showAsCaption=None , nameLen=None , pPos=None , pLen=None , level=None , field=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

field ¶

Values must be of type <class ‘int’>

level ¶

Values must be of type <class ‘int’>

name ¶

Values must be of type <class ‘str’>

nameLen ¶

Values must be of type <class ‘int’>

pLen ¶

Values must be of type <class ‘int’>

pPos ¶

Values must be of type <class ‘int’>

showAsCaption ¶

Values must be of type <class ‘bool’>

showCell ¶

Values must be of type <class ‘bool’>

showTip ¶

Values must be of type <class ‘bool’>

tagname = 'mps' ¶

class openpyxl.pivot.table. PageField ( fld=None , item=None , hier=None , name=None , cap=None , extLst=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

cap ¶

Values must be of type <class ‘str’>

extLst ¶

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

fld ¶

Values must be of type <class ‘int’>

hier ¶

Values must be of type <class ‘int’>

item ¶

Values must be of type <class ‘int’>

name ¶

Values must be of type <class ‘str’>

tagname = 'pageField' ¶

class openpyxl.pivot.table. PivotArea ( references=() , extLst=None , field=None , type='normal' , dataOnly=True , labelOnly=None , grandRow=None , grandCol=None , cacheIndex=None , outline=True , offset=None , collapsedLevelsAreSubtotals=None , axis=None , fieldPosition=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

axis ¶

Value must be one of {‘axisPage’, ‘axisRow’, ‘axisValues’, ‘axisCol’}

cacheIndex ¶

Values must be of type <class ‘bool’>

collapsedLevelsAreSubtotals ¶

Values must be of type <class ‘bool’>

dataOnly ¶

Values must be of type <class ‘bool’>

extLst ¶

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

field ¶

Values must be of type <class ‘int’>

fieldPosition ¶

Values must be of type <class ‘int’>

grandCol ¶

Values must be of type <class ‘bool’>

grandRow ¶

Values must be of type <class ‘bool’>

labelOnly ¶

Values must be of type <class ‘bool’>

offset ¶

Values must be of type <class ‘str’>

outline ¶

Values must be of type <class ‘bool’>

references ¶

Wrap a sequence in an containing object

tagname = 'pivotArea' ¶

type ¶

Value must be one of {‘data’, ‘all’, ‘topRight’, ‘topEnd’, ‘button’, ‘normal’, ‘origin’}

class openpyxl.pivot.table. PivotField ( items=() , autoSortScope=None , name=None , axis=None , dataField=None , subtotalCaption=None , showDropDowns=True , hiddenLevel=None , uniqueMemberProperty=None , compact=True , allDrilled=None , numFmtId=None , outline=True , subtotalTop=True , dragToRow=True , dragToCol=True , multipleItemSelectionAllowed=None , dragToPage=True , dragToData=True , dragOff=True , showAll=True , insertBlankRow=None , serverField=None , insertPageBreak=None , autoShow=None , topAutoShow=True , hideNewItems=None , measureFilter=None , includeNewItemsInFilter=None , itemPageCount=10 , sortType='manual' , dataSourceSort=None , nonAutoSortDefault=None , rankBy=None , defaultSubtotal=True , sumSubtotal=None , countASubtotal=None , avgSubtotal=None , maxSubtotal=None , minSubtotal=None , productSubtotal=None , countSubtotal=None , stdDevSubtotal=None , stdDevPSubtotal=None , varSubtotal=None , varPSubtotal=None , showPropCell=None , showPropTip=None , showPropAsCaption=None , defaultAttributeDrillState=None , extLst=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

allDrilled ¶

Values must be of type <class ‘bool’>

autoShow ¶

Values must be of type <class ‘bool’>

autoSortScope ¶

Values must be of type <class ‘openpyxl.pivot.table.AutoSortScope’>

avgSubtotal ¶

Values must be of type <class ‘bool’>

axis ¶

Value must be one of {‘axisPage’, ‘axisRow’, ‘axisValues’, ‘axisCol’}

compact ¶

Values must be of type <class ‘bool’>

countASubtotal ¶

Values must be of type <class ‘bool’>

countSubtotal ¶

Values must be of type <class ‘bool’>

dataField ¶

Values must be of type <class ‘bool’>

dataSourceSort ¶

Values must be of type <class ‘bool’>

defaultAttributeDrillState ¶

Values must be of type <class ‘bool’>

defaultSubtotal ¶

Values must be of type <class ‘bool’>

dragOff ¶

Values must be of type <class ‘bool’>

dragToCol ¶

Values must be of type <class ‘bool’>

dragToData ¶

Values must be of type <class ‘bool’>

dragToPage ¶

Values must be of type <class ‘bool’>

dragToRow ¶

Values must be of type <class ‘bool’>

extLst ¶

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

hiddenLevel ¶

Values must be of type <class ‘bool’>

hideNewItems ¶

Values must be of type <class ‘bool’>

includeNewItemsInFilter ¶

Values must be of type <class ‘bool’>

insertBlankRow ¶

Values must be of type <class ‘bool’>

insertPageBreak ¶

Values must be of type <class ‘bool’>

itemPageCount ¶

Values must be of type <class ‘int’>

项 ¶

Wrap a sequence in an containing object

maxSubtotal ¶

Values must be of type <class ‘bool’>

measureFilter ¶

Values must be of type <class ‘bool’>

minSubtotal ¶

Values must be of type <class ‘bool’>

multipleItemSelectionAllowed ¶

Values must be of type <class ‘bool’>

name ¶

Values must be of type <class ‘str’>

nonAutoSortDefault ¶

Values must be of type <class ‘bool’>

numFmtId ¶

Values must be of type <class ‘int’>

outline ¶

Values must be of type <class ‘bool’>

productSubtotal ¶

Values must be of type <class ‘bool’>

rankBy ¶

Values must be of type <class ‘int’>

serverField ¶

Values must be of type <class ‘bool’>

showAll ¶

Values must be of type <class ‘bool’>

showDropDowns ¶

Values must be of type <class ‘bool’>

showPropAsCaption ¶

Values must be of type <class ‘bool’>

showPropCell ¶

Values must be of type <class ‘bool’>

showPropTip ¶

Values must be of type <class ‘bool’>

sortType ¶

Value must be one of {‘descending’, ‘manual’, ‘ascending’}

stdDevPSubtotal ¶

Values must be of type <class ‘bool’>

stdDevSubtotal ¶

Values must be of type <class ‘bool’>

subtotalCaption ¶

Values must be of type <class ‘str’>

subtotalTop ¶

Values must be of type <class ‘bool’>

sumSubtotal ¶

Values must be of type <class ‘bool’>

tagname = 'pivotField' ¶

topAutoShow ¶

Values must be of type <class ‘bool’>

uniqueMemberProperty ¶

Values must be of type <class ‘str’>

varPSubtotal ¶

Values must be of type <class ‘bool’>

varSubtotal ¶

Values must be of type <class ‘bool’>

class openpyxl.pivot.table. PivotFilter ( fld=None , mpFld=None , type=None , evalOrder=None , id=None , iMeasureHier=None , iMeasureFld=None , name=None , description=None , stringValue1=None , stringValue2=None , autoFilter=None , extLst=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

autoFilter ¶

Values must be of type <class ‘openpyxl.worksheet.filters.AutoFilter’>

description ¶

Values must be of type <class ‘str’>

evalOrder ¶

Values must be of type <class ‘int’>

extLst ¶

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

fld ¶

Values must be of type <class ‘int’>

iMeasureFld ¶

Values must be of type <class ‘int’>

iMeasureHier ¶

Values must be of type <class ‘int’>

id ¶

Values must be of type <class ‘int’>

mpFld ¶

Values must be of type <class ‘int’>

name ¶

Values must be of type <class ‘str’>

stringValue1 ¶

Values must be of type <class ‘str’>

stringValue2 ¶

Values must be of type <class ‘str’>

tagname = 'filter' ¶

type ¶

Value must be one of {‘nextMonth’, ‘captionGreaterThanOrEqual’, ‘valueBetween’, ‘dateNewerThan’, ‘Q1’, ‘dateOlderThanOrEqual’, ‘M9’, ‘lastYear’, ‘M6’, ‘today’, ‘Q4’, ‘M1’, ‘M2’, ‘captionGreaterThan’, ‘M7’, ‘sum’, ‘nextQuarter’, ‘lastQuarter’, ‘thisQuarter’, ‘captionNotBeginsWith’, ‘valueLessThan’, ‘valueEqual’, ‘dateBetween’, ‘lastWeek’, ‘Q2’, ‘Q3’, ‘M12’, ‘captionLessThan’, ‘M3’, ‘dateEqual’, ‘captionNotContains’, ‘yearToDate’, ‘lastMonth’, ‘valueLessThanOrEqual’, ‘dateNotEqual’, ‘captionEndsWith’, ‘thisWeek’, ‘percent’, ‘nextWeek’, ‘captionNotEqual’, ‘thisYear’, ‘captionNotEndsWith’, ‘dateNewerThanOrEqual’, ‘captionEqual’, ‘yesterday’, ‘valueGreaterThanOrEqual’, ‘dateOlderThan’, ‘M4’, ‘nextYear’, ‘M10’, ‘valueNotEqual’, ‘valueGreaterThan’, ‘M8’, ‘thisMonth’, ‘valueNotBetween’, ‘captionBeginsWith’, ‘captionNotBetween’, ‘captionLessThanOrEqual’, ‘captionBetween’, ‘dateNotBetween’, ‘captionContains’, ‘count’, ‘unknown’, ‘tomorrow’, ‘M11’, ‘M5’}

class openpyxl.pivot.table. PivotFilters ( count=None , filter=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

count ¶

Values must be of type <class ‘int’>

filter ¶

Values must be of type <class ‘openpyxl.pivot.table.PivotFilter’>

class openpyxl.pivot.table. PivotHierarchy ( outline=None , multipleItemSelectionAllowed=None , subtotalTop=None , showInFieldList=None , dragToRow=None , dragToCol=None , dragToPage=None , dragToData=None , dragOff=None , includeNewItemsInFilter=None , caption=None , mps=() , members=None , extLst=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

caption ¶

Values must be of type <class ‘str’>

dragOff ¶

Values must be of type <class ‘bool’>

dragToCol ¶

Values must be of type <class ‘bool’>

dragToData ¶

Values must be of type <class ‘bool’>

dragToPage ¶

Values must be of type <class ‘bool’>

dragToRow ¶

Values must be of type <class ‘bool’>

extLst ¶

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

includeNewItemsInFilter ¶

Values must be of type <class ‘bool’>

members ¶

Values must be of type <class ‘openpyxl.pivot.table.MemberList’>

mps ¶

Wrap a sequence in an containing object

multipleItemSelectionAllowed ¶

Values must be of type <class ‘bool’>

outline ¶

Values must be of type <class ‘bool’>

showInFieldList ¶

Values must be of type <class ‘bool’>

subtotalTop ¶

Values must be of type <class ‘bool’>

tagname = 'pivotHierarchy' ¶

class openpyxl.pivot.table. PivotTableStyle ( name=None , showRowHeaders=None , showColHeaders=None , showRowStripes=None , showColStripes=None , showLastColumn=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

name ¶

Values must be of type <class ‘str’>

showColHeaders ¶

Values must be of type <class ‘bool’>

showColStripes ¶

Values must be of type <class ‘bool’>

showLastColumn ¶

Values must be of type <class ‘bool’>

showRowHeaders ¶

Values must be of type <class ‘bool’>

showRowStripes ¶

Values must be of type <class ‘bool’>

tagname = 'pivotTableStyleInfo' ¶

class openpyxl.pivot.table. 参考 ( field=None , count=None , selected=None , byPosition=None , relative=None , defaultSubtotal=None , sumSubtotal=None , countASubtotal=None , avgSubtotal=None , maxSubtotal=None , minSubtotal=None , productSubtotal=None , countSubtotal=None , stdDevSubtotal=None , stdDevPSubtotal=None , varSubtotal=None , varPSubtotal=None , x=None , extLst=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

avgSubtotal ¶

Values must be of type <class ‘bool’>

byPosition ¶

Values must be of type <class ‘bool’>

count ¶

countASubtotal ¶

Values must be of type <class ‘bool’>

countSubtotal ¶

Values must be of type <class ‘bool’>

defaultSubtotal ¶

Values must be of type <class ‘bool’>

extLst ¶

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

field ¶

Values must be of type <class ‘int’>

maxSubtotal ¶

Values must be of type <class ‘bool’>

minSubtotal ¶

Values must be of type <class ‘bool’>

productSubtotal ¶

Values must be of type <class ‘bool’>

relative ¶

Values must be of type <class ‘bool’>

selected ¶

Values must be of type <class ‘bool’>

stdDevPSubtotal ¶

Values must be of type <class ‘bool’>

stdDevSubtotal ¶

Values must be of type <class ‘bool’>

sumSubtotal ¶

Values must be of type <class ‘bool’>

tagname = 'reference' ¶

varPSubtotal ¶

Values must be of type <class ‘bool’>

varSubtotal ¶

Values must be of type <class ‘bool’>

x ¶

Values must be of type <class ‘int’>

class openpyxl.pivot.table. RowColField ( x=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

tagname = 'field' ¶

x ¶

Values must be of type <class ‘int’>

class openpyxl.pivot.table. RowColItem ( t='data' , r=0 , i=0 , x=() ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

i ¶

Values must be of type <class ‘int’>

r ¶

Values must be of type <class ‘int’>

t ¶

Value must be one of {‘data’, ‘default’, ‘countA’, ‘grand’, ‘stdDev’, ‘stdDevP’, ‘var’, ‘min’, ‘product’, ‘varP’, ‘max’, ‘avg’, ‘count’, ‘sum’, ‘blank’}

tagname = 'i' ¶

x ¶

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

class openpyxl.pivot.table. RowHierarchiesUsage ( count=None , rowHierarchyUsage=() ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

count ¶

rowHierarchyUsage ¶

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

tagname = 'rowHierarchiesUsage' ¶

class openpyxl.pivot.table. TableDefinition ( name=None , cacheId=None , dataOnRows=False , dataPosition=None , dataCaption=None , grandTotalCaption=None , errorCaption=None , showError=False , missingCaption=None , showMissing=True , pageStyle=None , pivotTableStyle=None , vacatedStyle=None , tag=None , updatedVersion=0 , minRefreshableVersion=0 , asteriskTotals=False , showItems=True , editData=False , disableFieldList=False , showCalcMbrs=True , visualTotals=True , showMultipleLabel=True , showDataDropDown=True , showDrill=True , printDrill=False , showMemberPropertyTips=True , showDataTips=True , enableWizard=True , enableDrill=True , enableFieldProperties=True , preserveFormatting=True , useAutoFormatting=False , pageWrap=0 , pageOverThenDown=False , subtotalHiddenItems=False , rowGrandTotals=True , colGrandTotals=True , fieldPrintTitles=False , itemPrintTitles=False , mergeItem=False , showDropZones=True , createdVersion=0 , indent=1 , showEmptyRow=False , showEmptyCol=False , showHeaders=True , compact=True , outline=False , outlineData=False , compactData=True , published=False , gridDropZones=False , immersive=True , multipleFieldFilters=None , chartFormat=0 , rowHeaderCaption=None , colHeaderCaption=None , fieldListSortAscending=None , mdxSubqueries=None , customListSort=None , autoFormatId=None , applyNumberFormats=False , applyBorderFormats=False , applyFontFormats=False , applyPatternFormats=False , applyAlignmentFormats=False , applyWidthHeightFormats=False , location=None , pivotFields=() , rowFields=() , rowItems=() , colFields=() , colItems=() , pageFields=() , dataFields=() , formats=() , conditionalFormats=() , chartFormats=() , pivotHierarchies=() , pivotTableStyleInfo=None , filters=() , rowHierarchiesUsage=None , colHierarchiesUsage=None , extLst=None , id=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

applyAlignmentFormats ¶

Values must be of type <class ‘bool’>

applyBorderFormats ¶

Values must be of type <class ‘bool’>

applyFontFormats ¶

Values must be of type <class ‘bool’>

applyNumberFormats ¶

Values must be of type <class ‘bool’>

applyPatternFormats ¶

Values must be of type <class ‘bool’>

applyWidthHeightFormats ¶

Values must be of type <class ‘bool’>

asteriskTotals ¶

Values must be of type <class ‘bool’>

autoFormatId ¶

Values must be of type <class ‘int’>

cache = None ¶

cacheId ¶

Values must be of type <class ‘int’>

chartFormat ¶

Values must be of type <class ‘int’>

chartFormats ¶

Wrap a sequence in an containing object

colFields ¶

Wrap a sequence in an containing object

colGrandTotals ¶

Values must be of type <class ‘bool’>

colHeaderCaption ¶

Values must be of type <class ‘str’>

colHierarchiesUsage ¶

Values must be of type <class ‘openpyxl.pivot.table.ColHierarchiesUsage’>

colItems ¶

Wrap a sequence in an containing object

compact ¶

Values must be of type <class ‘bool’>

compactData ¶

Values must be of type <class ‘bool’>

conditionalFormats ¶

Wrap a sequence in an containing object

createdVersion ¶

Values must be of type <class ‘int’>

customListSort ¶

Values must be of type <class ‘bool’>

dataCaption ¶

Values must be of type <class ‘str’>

dataFields ¶

Wrap a sequence in an containing object

dataOnRows ¶

Values must be of type <class ‘bool’>

dataPosition ¶

Values must be of type <class ‘int’>

disableFieldList ¶

Values must be of type <class ‘bool’>

editData ¶

Values must be of type <class ‘bool’>

enableDrill ¶

Values must be of type <class ‘bool’>

enableFieldProperties ¶

Values must be of type <class ‘bool’>

enableWizard ¶

Values must be of type <class ‘bool’>

errorCaption ¶

Values must be of type <class ‘str’>

extLst ¶

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

fieldListSortAscending ¶

Values must be of type <class ‘bool’>

fieldPrintTitles ¶

Values must be of type <class ‘bool’>

过滤 ¶

Wrap a sequence in an containing object

formats ¶

Wrap a sequence in an containing object

grandTotalCaption ¶

Values must be of type <class ‘str’>

gridDropZones ¶

Values must be of type <class ‘bool’>

id ¶

Values must be of type <class ‘str’>

immersive ¶

Values must be of type <class ‘bool’>

indent ¶

Values must be of type <class ‘int’>

itemPrintTitles ¶

Values must be of type <class ‘bool’>

location ¶

Values must be of type <class ‘openpyxl.pivot.table.Location’>

mdxSubqueries ¶

Values must be of type <class ‘bool’>

mergeItem ¶

Values must be of type <class ‘bool’>

mime_type = 'application/vnd.openxmlformats-officedocument.spreadsheetml.pivotTable+xml' ¶

minRefreshableVersion ¶

Values must be of type <class ‘int’>

missingCaption ¶

Values must be of type <class ‘str’>

multipleFieldFilters ¶

Values must be of type <class ‘bool’>

name ¶

Values must be of type <class ‘str’>

outline ¶

Values must be of type <class ‘bool’>

outlineData ¶

Values must be of type <class ‘bool’>

pageFields ¶

Wrap a sequence in an containing object

pageOverThenDown ¶

Values must be of type <class ‘bool’>

pageStyle ¶

Values must be of type <class ‘str’>

pageWrap ¶

Values must be of type <class ‘int’>

path ¶

pivotFields ¶

Wrap a sequence in an containing object

pivotHierarchies ¶

Wrap a sequence in an containing object

pivotTableStyle ¶

Values must be of type <class ‘str’>

pivotTableStyleInfo ¶

Values must be of type <class ‘openpyxl.pivot.table.PivotTableStyle’>

preserveFormatting ¶

Values must be of type <class ‘bool’>

printDrill ¶

Values must be of type <class ‘bool’>

published ¶

Values must be of type <class ‘bool’>

rel_type = 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/pivotTable' ¶

rowFields ¶

Wrap a sequence in an containing object

rowGrandTotals ¶

Values must be of type <class ‘bool’>

rowHeaderCaption ¶

Values must be of type <class ‘str’>

rowHierarchiesUsage ¶

Values must be of type <class ‘openpyxl.pivot.table.RowHierarchiesUsage’>

rowItems ¶

Wrap a sequence in an containing object

showCalcMbrs ¶

Values must be of type <class ‘bool’>

showDataDropDown ¶

Values must be of type <class ‘bool’>

showDataTips ¶

Values must be of type <class ‘bool’>

showDrill ¶

Values must be of type <class ‘bool’>

showDropZones ¶

Values must be of type <class ‘bool’>

showEmptyCol ¶

Values must be of type <class ‘bool’>

showEmptyRow ¶

Values must be of type <class ‘bool’>

showError ¶

Values must be of type <class ‘bool’>

showHeaders ¶

Values must be of type <class ‘bool’>

showItems ¶

Values must be of type <class ‘bool’>

showMemberPropertyTips ¶

Values must be of type <class ‘bool’>

showMissing ¶

Values must be of type <class ‘bool’>

showMultipleLabel ¶

Values must be of type <class ‘bool’>

subtotalHiddenItems ¶

Values must be of type <class ‘bool’>

tag ¶

Values must be of type <class ‘str’>

tagname = 'pivotTableDefinition' ¶

to_tree ( ) [source] ¶

updatedVersion ¶

Values must be of type <class ‘int’>

useAutoFormatting ¶

Values must be of type <class ‘bool’>

vacatedStyle ¶

Values must be of type <class ‘str’>

visualTotals ¶

Values must be of type <class ‘bool’>