# openpyxl.pivot.table module

class openpyxl.pivot.table.AutoSortScope(pivotArea=None)

  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)

  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=())

  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)

  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 [‘data’, ‘field’, ‘selection’]

  tagname = 'conditionalFormat'
  type

    Value must be one of [‘all’, ‘column’, ‘row’]

class openpyxl.pivot.table.ConditionalFormatList(conditionalFormat=(), count=None)

  Bases: `Serialisable`

  by_priority()

    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'
  to_tree(tagname=None)

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

  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 [‘difference’, ‘index’, ‘normal’, ‘percent’, ‘percentDiff’, ‘percentOfCol’, ‘percentOfRow’, ‘percentOfTotal’, ‘runTotal’]

  subtotal

    Value must be one of [‘average’, ‘count’, ‘countNums’, ‘max’, ‘min’, ‘product’, ‘stdDev’, ‘stdDevp’, ‘sum’, ‘var’, ‘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)

  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 [‘avg’, ‘blank’, ‘count’, ‘countA’, ‘data’, ‘default’, ‘grand’, ‘max’, ‘min’, ‘product’, ‘stdDev’, ‘stdDevP’, ‘sum’, ‘var’, ‘varP’]

  tagname = 'item'
  x

    Values must be of type <class ‘int’>

class openpyxl.pivot.table.Format(action='formatting', dxfId=None, pivotArea=None, extLst=None)

  Bases: `Serialisable`

  action

    Value must be one of [‘blank’, ‘drill’, ‘formatting’, ‘formula’]

  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)

  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)

  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=())

  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)

  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)

  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)

  Bases: `Serialisable`

  axis

    Value must be one of [‘axisCol’, ‘axisPage’, ‘axisRow’, ‘axisValues’]

  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 [‘all’, ‘button’, ‘data’, ‘normal’, ‘origin’, ‘topEnd’, ‘topRight’]

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)

  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 [‘axisCol’, ‘axisPage’, ‘axisRow’, ‘axisValues’]

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

  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 [‘ascending’, ‘descending’, ‘manual’]

  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)

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

class openpyxl.pivot.table.PivotFilters(count=None, filter=None)

  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)

  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)

  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)

  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)

  Bases: `Serialisable`

  tagname = 'field'
  x

    Values must be of type <class ‘int’>

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

  Bases: `Serialisable`

  i

    Values must be of type <class ‘int’>

  r

    Values must be of type <class ‘int’>

  t

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

  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=())

  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)

  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

  formatted_fields()

    Map fields to associated conditional formats by priority

  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'
  to_tree()
  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’>