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

openpyxl.pivot.cache 模块 ¶

class openpyxl.pivot.cache. CacheDefinition ( invalid=None , saveData=None , refreshOnLoad=None , optimizeMemory=None , enableRefresh=None , refreshedBy=None , refreshedDate=None , refreshedDateIso=None , backgroundQuery=None , missingItemsLimit=None , createdVersion=None , refreshedVersion=None , minRefreshableVersion=None , recordCount=None , upgradeOnRefresh=None , tupleCache=None , supportSubquery=None , supportAdvancedDrill=None , cacheSource=None , cacheFields=() , cacheHierarchies=() , kpis=() , calculatedItems=() , calculatedMembers=() , dimensions=() , measureGroups=() , maps=() , extLst=None , id=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

backgroundQuery ¶

Values must be of type <class ‘bool’>

cacheFields ¶

Wrap a sequence in an containing object

cacheHierarchies ¶

Wrap a sequence in an containing object

cacheSource ¶

Values must be of type <class ‘openpyxl.pivot.cache.CacheSource’>

calculatedItems ¶

Wrap a sequence in an containing object

calculatedMembers ¶

Wrap a sequence in an containing object

createdVersion ¶

Values must be of type <class ‘int’>

dimensions ¶

Wrap a sequence in an containing object

enableRefresh ¶

Values must be of type <class ‘bool’>

extLst ¶

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

id ¶

Values must be of type <class ‘str’>

invalid ¶

Values must be of type <class ‘bool’>

kpis ¶

Wrap a sequence in an containing object

maps ¶

Wrap a sequence in an containing object

measureGroups ¶

Wrap a sequence in an containing object

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

minRefreshableVersion ¶

Values must be of type <class ‘int’>

missingItemsLimit ¶

Values must be of type <class ‘int’>

optimizeMemory ¶

Values must be of type <class ‘bool’>

path ¶

recordCount ¶

Values must be of type <class ‘int’>

records = None ¶

refreshOnLoad ¶

Values must be of type <class ‘bool’>

refreshedBy ¶

Values must be of type <class ‘str’>

refreshedDate ¶

Values must be of type <class ‘float’>

refreshedDateIso ¶

Values must be of type <class ‘datetime.datetime’>

refreshedVersion ¶

Values must be of type <class ‘int’>

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

saveData ¶

Values must be of type <class ‘bool’>

supportAdvancedDrill ¶

Values must be of type <class ‘bool’>

supportSubquery ¶

Values must be of type <class ‘bool’>

tagname = 'pivotCacheDefinition' ¶

to_tree ( ) [source] ¶

tupleCache ¶

Values must be of type <class ‘openpyxl.pivot.cache.TupleCache’>

upgradeOnRefresh ¶

Values must be of type <class ‘bool’>

class openpyxl.pivot.cache. CacheField ( sharedItems=None , fieldGroup=None , mpMap=None , extLst=None , name=None , caption=None , propertyName=None , serverField=None , uniqueList=True , numFmtId=None , formula=None , sqlType=0 , hierarchy=0 , level=0 , databaseField=True , mappingCount=None , memberPropertyField=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

caption ¶

Values must be of type <class ‘str’>

databaseField ¶

Values must be of type <class ‘bool’>

extLst ¶

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

fieldGroup ¶

Values must be of type <class ‘openpyxl.pivot.cache.FieldGroup’>

formula ¶

Values must be of type <class ‘str’>

hierarchy ¶

Values must be of type <class ‘int’>

level ¶

Values must be of type <class ‘int’>

mappingCount ¶

Values must be of type <class ‘int’>

memberPropertyField ¶

Values must be of type <class ‘bool’>

mpMap ¶

Values must be of type <class ‘int’>

name ¶

Values must be of type <class ‘str’>

numFmtId ¶

Values must be of type <class ‘int’>

propertyName ¶

Values must be of type <class ‘str’>

serverField ¶

Values must be of type <class ‘bool’>

sharedItems ¶

Values must be of type <class ‘openpyxl.pivot.cache.SharedItems’>

sqlType ¶

Values must be of type <class ‘int’>

tagname = 'cacheField' ¶

uniqueList ¶

Values must be of type <class ‘bool’>

class openpyxl.pivot.cache. CacheHierarchy ( uniqueName='' , caption=None , measure=None , set=None , parentSet=None , iconSet=0 , attribute=None , time=None , keyAttribute=None , defaultMemberUniqueName=None , allUniqueName=None , allCaption=None , dimensionUniqueName=None , displayFolder=None , measureGroup=None , measures=None , count=None , oneField=None , memberValueDatatype=None , unbalanced=None , unbalancedGroup=None , hidden=None , fieldsUsage=None , groupLevels=None , extLst=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

allCaption ¶

Values must be of type <class ‘str’>

allUniqueName ¶

Values must be of type <class ‘str’>

属性 ¶

Values must be of type <class ‘bool’>

caption ¶

Values must be of type <class ‘str’>

count ¶

Values must be of type <class ‘int’>

defaultMemberUniqueName ¶

Values must be of type <class ‘str’>

dimensionUniqueName ¶

Values must be of type <class ‘str’>

displayFolder ¶

Values must be of type <class ‘str’>

extLst ¶

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

fieldsUsage ¶

Values must be of type <class ‘openpyxl.pivot.cache.FieldsUsage’>

groupLevels ¶

Values must be of type <class ‘openpyxl.pivot.cache.GroupLevels’>

hidden ¶

Values must be of type <class ‘bool’>

iconSet ¶

Values must be of type <class ‘int’>

keyAttribute ¶

Values must be of type <class ‘bool’>

measure ¶

Values must be of type <class ‘bool’>

measureGroup ¶

Values must be of type <class ‘str’>

measures ¶

Values must be of type <class ‘bool’>

memberValueDatatype ¶

Values must be of type <class ‘int’>

oneField ¶

Values must be of type <class ‘bool’>

parentSet ¶

Values must be of type <class ‘int’>

set ¶

Values must be of type <class ‘bool’>

tagname = 'cacheHierarchy' ¶

time ¶

Values must be of type <class ‘bool’>

unbalanced ¶

Values must be of type <class ‘bool’>

unbalancedGroup ¶

Values must be of type <class ‘bool’>

uniqueName ¶

Values must be of type <class ‘str’>

class openpyxl.pivot.cache. CacheSource ( type=None , connectionId=None , worksheetSource=None , consolidation=None , extLst=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

connectionId ¶

Values must be of type <class ‘int’>

consolidation ¶

Values must be of type <class ‘openpyxl.pivot.cache.Consolidation’>

extLst ¶

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

tagname = 'cacheSource' ¶

type ¶

Value must be one of {‘external’, ‘scenario’, ‘consolidation’, ‘worksheet’}

worksheetSource ¶

Values must be of type <class ‘openpyxl.pivot.cache.WorksheetSource’>

class openpyxl.pivot.cache. CalculatedItem ( field=None , formula=None , pivotArea=None , extLst=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

extLst ¶

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

field ¶

Values must be of type <class ‘int’>

formula ¶

Values must be of type <class ‘str’>

pivotArea ¶

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

tagname = 'calculatedItem' ¶

class openpyxl.pivot.cache. CalculatedMember ( name=None , mdx=None , memberName=None , hierarchy=None , parent=None , solveOrder=None , set=None , extLst=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

extLst ¶

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

hierarchy ¶

Values must be of type <class ‘str’>

mdx ¶

Values must be of type <class ‘str’>

memberName ¶

Values must be of type <class ‘str’>

name ¶

Values must be of type <class ‘str’>

parent ¶

Values must be of type <class ‘str’>

set ¶

Values must be of type <class ‘bool’>

solveOrder ¶

Values must be of type <class ‘int’>

tagname = 'calculatedMember' ¶

class openpyxl.pivot.cache. Consolidation ( autoPage=None , pages=() , rangeSets=() ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

autoPage ¶

Values must be of type <class ‘bool’>

pages ¶

Wrap a sequence in an containing object

rangeSets ¶

Wrap a sequence in an containing object

tagname = 'consolidation' ¶

class openpyxl.pivot.cache. DiscretePr ( count=None , x=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

count ¶

Values must be of type <class ‘int’>

tagname = 'discretePr' ¶

x ¶

Values must be of type <class ‘int’>

class openpyxl.pivot.cache. FieldGroup ( par=None , base=None , rangePr=None , discretePr=None , groupItems=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

base ¶

Values must be of type <class ‘int’>

discretePr ¶

Values must be of type <class ‘openpyxl.pivot.cache.DiscretePr’>

groupItems ¶

Values must be of type <class ‘openpyxl.pivot.cache.GroupItems’>

par ¶

Values must be of type <class ‘int’>

rangePr ¶

Values must be of type <class ‘openpyxl.pivot.cache.RangePr’>

tagname = 'fieldGroup' ¶

class openpyxl.pivot.cache. FieldUsage ( x=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

tagname = 'fieldUsage' ¶

x ¶

Values must be of type <class ‘int’>

class openpyxl.pivot.cache. FieldsUsage ( count=None , fieldUsage=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

count ¶

Values must be of type <class ‘int’>

fieldUsage ¶

Values must be of type <class ‘openpyxl.pivot.cache.FieldUsage’>

class openpyxl.pivot.cache. GroupItems ( count=None , m=() , n=() , b=() , e=() , s=() , d=() ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

b ¶

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

count ¶

d ¶

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

e ¶

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

m ¶

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

n ¶

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

s ¶

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

tagname = 'groupItems' ¶

class openpyxl.pivot.cache. GroupLevel ( uniqueName=None , caption=None , user=None , customRollUp=None , groups=None , extLst=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

caption ¶

Values must be of type <class ‘str’>

customRollUp ¶

Values must be of type <class ‘bool’>

extLst ¶

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

groups ¶

Values must be of type <class ‘openpyxl.pivot.cache.Groups’>

tagname = 'groupLevel' ¶

uniqueName ¶

Values must be of type <class ‘str’>

user ¶

Values must be of type <class ‘bool’>

class openpyxl.pivot.cache. GroupLevels ( count=None , groupLevel=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

count ¶

Values must be of type <class ‘int’>

groupLevel ¶

Values must be of type <class ‘openpyxl.pivot.cache.GroupLevel’>

class openpyxl.pivot.cache. GroupMember ( uniqueName=None , group=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

group ¶

Values must be of type <class ‘bool’>

tagname = 'groupMember' ¶

uniqueName ¶

Values must be of type <class ‘str’>

class openpyxl.pivot.cache. GroupMembers ( count=None , groupMember=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

count ¶

Values must be of type <class ‘int’>

groupMember ¶

Values must be of type <class ‘openpyxl.pivot.cache.GroupMember’>

class openpyxl.pivot.cache. Groups ( count=None , group=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

count ¶

Values must be of type <class ‘int’>

group ¶

Values must be of type <class ‘openpyxl.pivot.cache.LevelGroup’>

tagname = 'groups' ¶

class openpyxl.pivot.cache. LevelGroup ( name=None , uniqueName=None , caption=None , uniqueParent=None , id=None , groupMembers=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

caption ¶

Values must be of type <class ‘str’>

groupMembers ¶

Values must be of type <class ‘openpyxl.pivot.cache.GroupMembers’>

id ¶

Values must be of type <class ‘int’>

name ¶

Values must be of type <class ‘str’>

tagname = 'levelGroup' ¶

uniqueName ¶

Values must be of type <class ‘str’>

uniqueParent ¶

Values must be of type <class ‘str’>

class openpyxl.pivot.cache. MeasureDimensionMap ( measureGroup=None , dimension=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

dimension ¶

Values must be of type <class ‘int’>

measureGroup ¶

Values must be of type <class ‘int’>

tagname = 'map' ¶

class openpyxl.pivot.cache. MeasureGroup ( name=None , caption=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

caption ¶

Values must be of type <class ‘str’>

name ¶

Values must be of type <class ‘str’>

tagname = 'measureGroup' ¶

class openpyxl.pivot.cache. OLAPSet ( count=None , maxRank=None , setDefinition=None , sortType=None , queryFailed=None , tpls=None , sortByTuple=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

count ¶

Values must be of type <class ‘int’>

maxRank ¶

Values must be of type <class ‘int’>

queryFailed ¶

Values must be of type <class ‘bool’>

setDefinition ¶

Values must be of type <class ‘str’>

sortByTuple ¶

Values must be of type <class ‘openpyxl.pivot.fields.TupleList’>

sortType ¶

Value must be one of {‘ascendingNatural’, ‘descending’, ‘ascendingAlpha’, ‘ascending’, ‘descendingNatural’, ‘descendingAlpha’}

tagname = 'set' ¶

tpls ¶

Values must be of type <class ‘openpyxl.pivot.fields.TupleList’>

class openpyxl.pivot.cache. OLAPSets ( count=None , set=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

count ¶

Values must be of type <class ‘int’>

set ¶

Values must be of type <class ‘openpyxl.pivot.cache.OLAPSet’>

class openpyxl.pivot.cache. PCDKPI ( uniqueName=None , caption=None , displayFolder=None , measureGroup=None , parent=None , value=None , goal=None , status=None , trend=None , weight=None , time=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

caption ¶

Values must be of type <class ‘str’>

displayFolder ¶

Values must be of type <class ‘str’>

goal ¶

Values must be of type <class ‘str’>

measureGroup ¶

Values must be of type <class ‘str’>

parent ¶

Values must be of type <class ‘str’>

status ¶

Values must be of type <class ‘str’>

tagname = 'pCDKPI' ¶

time ¶

Values must be of type <class ‘str’>

trend ¶

Values must be of type <class ‘str’>

uniqueName ¶

Values must be of type <class ‘str’>

值 ¶

Values must be of type <class ‘str’>

weight ¶

Values must be of type <class ‘str’>

class openpyxl.pivot.cache. PCDSDTCEntries ( count=None , m=None , n=None , e=None , s=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

count ¶

Values must be of type <class ‘int’>

e ¶

Values must be of type <class ‘openpyxl.pivot.fields.Error’>

m ¶

Values must be of type <class ‘openpyxl.pivot.fields.Missing’>

n ¶

Values must be of type <class ‘openpyxl.pivot.fields.Number’>

s ¶

Values must be of type <class ‘openpyxl.pivot.fields.Text’>

tagname = 'pCDSDTCEntries' ¶

class openpyxl.pivot.cache. Page ( count=None , pageItem=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

count ¶

pageItem ¶

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

tagname = 'PCDSCPage' ¶

class openpyxl.pivot.cache. PageItem ( name=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

name ¶

Values must be of type <class ‘str’>

tagname = 'pageItem' ¶

class openpyxl.pivot.cache. PivotDimension ( measure=None , name=None , uniqueName=None , caption=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

caption ¶

Values must be of type <class ‘str’>

measure ¶

Values must be of type <class ‘bool’>

name ¶

Values must be of type <class ‘str’>

tagname = 'dimension' ¶

uniqueName ¶

Values must be of type <class ‘str’>

class openpyxl.pivot.cache. Query ( mdx=None , tpls=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

mdx ¶

Values must be of type <class ‘str’>

tagname = 'query' ¶

tpls ¶

Values must be of type <class ‘openpyxl.pivot.fields.TupleList’>

class openpyxl.pivot.cache. QueryCache ( count=None , query=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

count ¶

Values must be of type <class ‘int’>

query ¶

Values must be of type <class ‘openpyxl.pivot.cache.Query’>

tagname = 'queryCache' ¶

class openpyxl.pivot.cache. RangePr ( autoStart=True , autoEnd=True , groupBy=<class 'range'> , startNum=None , endNum=None , startDate=None , endDate=None , groupInterval=1 ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

autoEnd ¶

Values must be of type <class ‘bool’>

autoStart ¶

Values must be of type <class ‘bool’>

endDate ¶

Values must be of type <class ‘datetime.datetime’>

endNum ¶

Values must be of type <class ‘float’>

groupBy ¶

Value must be one of {‘minutes’, ‘quarters’, ‘months’, ‘seconds’, ‘hours’, ‘days’, ‘years’, ‘range’}

groupInterval ¶

Values must be of type <class ‘float’>

startDate ¶

Values must be of type <class ‘datetime.datetime’>

startNum ¶

Values must be of type <class ‘float’>

tagname = 'rangePr' ¶

class openpyxl.pivot.cache. RangeSet ( i1=None , i2=None , i3=None , i4=None , ref=None , name=None , sheet=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

i1 ¶

Values must be of type <class ‘int’>

i2 ¶

Values must be of type <class ‘int’>

i3 ¶

Values must be of type <class ‘int’>

i4 ¶

Values must be of type <class ‘int’>

name ¶

Values must be of type <class ‘str’>

ref ¶

Values must be of type <class ‘str’>

sheet ¶

Values must be of type <class ‘str’>

tagname = 'rangeSet' ¶

class openpyxl.pivot.cache. ServerFormat ( culture=None , format=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

culture ¶

Values must be of type <class ‘str’>

format ¶

Values must be of type <class ‘str’>

tagname = 'serverFormat' ¶

class openpyxl.pivot.cache. ServerFormatList ( count=None , serverFormat=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

count ¶

serverFormat ¶

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

tagname = 'serverFormats' ¶

class openpyxl.pivot.cache. SharedItems ( _fields=() , containsSemiMixedTypes=None , containsNonDate=None , containsDate=None , containsString=None , containsBlank=None , containsMixedTypes=None , containsNumber=None , containsInteger=None , minValue=None , maxValue=None , minDate=None , maxDate=None , count=None , longText=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

b ¶

Allow a multisequence to be built up from parts

Excluded from the instance __elements__ or __attrs__ as is effectively an Alias

containsBlank ¶

Values must be of type <class ‘bool’>

containsDate ¶

Values must be of type <class ‘bool’>

containsInteger ¶

Values must be of type <class ‘bool’>

containsMixedTypes ¶

Values must be of type <class ‘bool’>

containsNonDate ¶

Values must be of type <class ‘bool’>

containsNumber ¶

Values must be of type <class ‘bool’>

containsSemiMixedTypes ¶

Values must be of type <class ‘bool’>

containsString ¶

Values must be of type <class ‘bool’>

count ¶

d ¶

Allow a multisequence to be built up from parts

Excluded from the instance __elements__ or __attrs__ as is effectively an Alias

e ¶

Allow a multisequence to be built up from parts

Excluded from the instance __elements__ or __attrs__ as is effectively an Alias

longText ¶

Values must be of type <class ‘bool’>

m ¶

Allow a multisequence to be built up from parts

Excluded from the instance __elements__ or __attrs__ as is effectively an Alias

maxDate ¶

Values must be of type <class ‘datetime.datetime’>

maxValue ¶

Values must be of type <class ‘float’>

minDate ¶

Values must be of type <class ‘datetime.datetime’>

minValue ¶

Values must be of type <class ‘float’>

n ¶

Allow a multisequence to be built up from parts

Excluded from the instance __elements__ or __attrs__ as is effectively an Alias

s ¶

Allow a multisequence to be built up from parts

Excluded from the instance __elements__ or __attrs__ as is effectively an Alias

tagname = 'sharedItems' ¶

class openpyxl.pivot.cache. TupleCache ( entries=None , sets=None , queryCache=None , serverFormats=None , extLst=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

entries ¶

Values must be of type <class ‘openpyxl.pivot.cache.PCDSDTCEntries’>

extLst ¶

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

queryCache ¶

Values must be of type <class ‘openpyxl.pivot.cache.QueryCache’>

serverFormats ¶

Values must be of type <class ‘openpyxl.pivot.cache.ServerFormatList’>

sets ¶

Values must be of type <class ‘openpyxl.pivot.cache.OLAPSets’>

tagname = 'tupleCache' ¶

class openpyxl.pivot.cache. WorksheetSource ( ref=None , name=None , sheet=None ) [source] ¶

Bases: openpyxl.descriptors.serialisable.Serialisable

name ¶

Values must be of type <class ‘str’>

ref ¶

Values must be of type <class ‘str’>

sheet ¶

Values must be of type <class ‘str’>

tagname = 'worksheetSource' ¶