openpyxl.pivot.table module
- class openpyxl.pivot.table.AutoSortScope(pivotArea=None)[source]
Bases:
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:
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:
Serialisable- colHierarchyUsage
A sequence (list or tuple) that may only contain objects of the declared type
- property count
- tagname = 'colHierarchiesUsage'
- class openpyxl.pivot.table.ConditionalFormat(scope='selection', type=None, priority=None, pivotAreas=(), extLst=None)[source]
Bases:
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 {‘field’, ‘data’, ‘selection’}
- tagname = 'conditionalFormat'
- type
Value must be one of {‘column’, ‘all’, ‘row’}
- class openpyxl.pivot.table.ConditionalFormatList(conditionalFormat=(), count=None)[source]
Bases:
Serialisable- by_priority()[source]
Return a dictionary of format objects keyed by (field id and format property). This can be used to map the formats to field but also to dedupe to match worksheet definitions which are grouped by cell range
- conditionalFormat
A sequence (list or tuple) that may only contain objects of the declared type
- property count
- tagname = 'conditionalFormats'
- class openpyxl.pivot.table.DataField(name=None, fld=None, subtotal='sum', showDataAs='normal', baseField=-1, baseItem=1048832, numFmtId=None, extLst=None)[source]
Bases:
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 {‘percentOfCol’, ‘normal’, ‘difference’, ‘percentDiff’, ‘percent’, ‘runTotal’, ‘percentOfTotal’, ‘index’, ‘percentOfRow’}
- subtotal
Value must be one of {‘sum’, ‘var’, ‘min’, ‘product’, ‘stdDev’, ‘countNums’, ‘average’, ‘stdDevp’, ‘varp’, ‘max’, ‘count’}
- 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:
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 {‘sum’, ‘var’, ‘min’, ‘default’, ‘product’, ‘stdDev’, ‘stdDevP’, ‘varP’, ‘count’, ‘grand’, ‘avg’, ‘countA’, ‘blank’, ‘data’, ‘max’}
- tagname = 'item'
- x
Values must be of type <class ‘int’>
- class openpyxl.pivot.table.Format(action='formatting', dxfId=None, pivotArea=None, extLst=None)[source]
Bases:
Serialisable- action
Value must be one of {‘formula’, ‘formatting’, ‘blank’, ‘drill’}
- 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:
Serialisable- hierarchyUsage
Values must be of type <class ‘int’>
- tagname = 'hierarchyUsage'
- class openpyxl.pivot.table.Location(ref=None, firstHeaderRow=None, firstDataRow=None, firstDataCol=None, rowPageCount=None, colPageCount=None)[source]
Bases:
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:
Serialisable- property 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:
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:
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:
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 {‘origin’, ‘button’, ‘topRight’, ‘topEnd’, ‘normal’, ‘all’, ‘data’}
- 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:
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’>
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’>
- items
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 {‘manual’, ‘ascending’, ‘descending’}
- 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:
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 {‘sum’, ‘captionEqual’, ‘captionGreaterThan’, ‘Q3’, ‘captionLessThan’, ‘M1’, ‘captionGreaterThanOrEqual’, ‘dateNotBetween’, ‘captionNotBeginsWith’, ‘valueNotBetween’, ‘today’, ‘M3’, ‘percent’, ‘dateOlderThan’, ‘lastMonth’, ‘M5’, ‘nextYear’, ‘dateOlderThanOrEqual’, ‘thisYear’, ‘dateNewerThanOrEqual’, ‘dateBetween’, ‘valueNotEqual’, ‘valueGreaterThan’, ‘valueLessThan’, ‘yearToDate’, ‘dateNewerThan’, ‘valueGreaterThanOrEqual’, ‘valueEqual’, ‘captionNotEqual’, ‘Q2’, ‘Q4’, ‘M4’, ‘M2’, ‘M10’, ‘captionNotContains’, ‘lastWeek’, ‘valueLessThanOrEqual’, ‘thisQuarter’, ‘unknown’, ‘nextMonth’, ‘nextQuarter’, ‘captionLessThanOrEqual’, ‘captionEndsWith’, ‘thisWeek’, ‘M8’, ‘captionBetween’, ‘dateEqual’, ‘M11’, ‘Q1’, ‘tomorrow’, ‘thisMonth’, ‘M12’, ‘M9’, ‘yesterday’, ‘M6’, ‘M7’, ‘captionNotEndsWith’, ‘lastQuarter’, ‘captionContains’, ‘valueBetween’, ‘nextWeek’, ‘dateNotEqual’, ‘captionNotBetween’, ‘lastYear’, ‘captionBeginsWith’, ‘count’}
- class openpyxl.pivot.table.PivotFilters(count=None, filter=None)[source]
Bases:
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:
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:
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.Reference(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=(), extLst=None)[source]
Bases:
Serialisable- avgSubtotal
Values must be of type <class ‘bool’>
- byPosition
Values must be of type <class ‘bool’>
- property 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
A sequence (list or tuple) that may only contain objects of the declared type
- class openpyxl.pivot.table.RowColField(x=None)[source]
Bases:
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:
Serialisable- i
Values must be of type <class ‘int’>
- r
Values must be of type <class ‘int’>
- t
Value must be one of {‘sum’, ‘var’, ‘min’, ‘default’, ‘product’, ‘stdDev’, ‘stdDevP’, ‘varP’, ‘count’, ‘grand’, ‘avg’, ‘countA’, ‘blank’, ‘data’, ‘max’}
- 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:
Serialisable- property 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=None, chartFormats=(), pivotHierarchies=(), pivotTableStyleInfo=None, filters=(), rowHierarchiesUsage=None, colHierarchiesUsage=None, extLst=None, id=None)[source]
Bases:
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
Values must be of type <class ‘openpyxl.pivot.table.ConditionalFormatList’>
- 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’>
- filters
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’>
- property 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’>
- property summary
Provide a simplified summary of the table
- tag
Values must be of type <class ‘str’>
- tagname = 'pivotTableDefinition'
- 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’>