openpyxl.pivot.table module¶
- class openpyxl.pivot.table.AutoSortScope(pivotArea=None)[源代码]¶
基类：
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)[源代码]¶
基类：
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=())[源代码]¶
基类：
openpyxl.descriptors.serialisable.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)[源代码]¶
基类：
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 {‘selection’, ‘field’, ‘data’}
- 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)[源代码]¶
基类：
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 {‘percentOfCol’, ‘runTotal’, ‘percentOfRow’, ‘difference’, ‘index’, ‘percent’, ‘normal’, ‘percentOfTotal’, ‘percentDiff’}
- subtotal¶
Value must be one of {‘min’, ‘product’, ‘countNums’, ‘sum’, ‘average’, ‘max’, ‘stdDevp’, ‘varp’, ‘count’, ‘var’, ‘stdDev’}
- 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)[源代码]¶
基类：
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 {‘countA’, ‘min’, ‘product’, ‘grand’, ‘sum’, ‘stdDevP’, ‘max’, ‘blank’, ‘data’, ‘varP’, ‘count’, ‘var’, ‘default’, ‘stdDev’, ‘avg’}
- tagname = 'item'¶
- x¶
Values must be of type <class ‘int’>
- class openpyxl.pivot.table.Format(action='formatting', dxfId=None, pivotArea=None, extLst=None)[源代码]¶
基类：
openpyxl.descriptors.serialisable.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)[源代码]¶
基类：
openpyxl.descriptors.serialisable.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)[源代码]¶
基类：
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=())[源代码]¶
基类：
openpyxl.descriptors.serialisable.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)[源代码]¶
基类：
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)[源代码]¶
基类：
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)[源代码]¶
基类：
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 {‘topRight’, ‘all’, ‘data’, ‘topEnd’, ‘button’, ‘origin’, ‘normal’}
- 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)[源代码]¶
基类：
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’>
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’, ‘descending’, ‘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)[源代码]¶
基类：
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 {‘thisWeek’, ‘tomorrow’, ‘unknown’, ‘captionEndsWith’, ‘valueNotEqual’, ‘valueLessThan’, ‘dateOlderThanOrEqual’, ‘Q3’, ‘M8’, ‘M6’, ‘M11’, ‘today’, ‘Q2’, ‘nextQuarter’, ‘count’, ‘lastMonth’, ‘M1’, ‘lastYear’, ‘captionLessThanOrEqual’, ‘thisYear’, ‘valueGreaterThan’, ‘captionBeginsWith’, ‘captionNotEndsWith’, ‘yearToDate’, ‘lastQuarter’, ‘captionGreaterThan’, ‘dateBetween’, ‘thisMonth’, ‘nextMonth’, ‘captionLessThan’, ‘dateOlderThan’, ‘percent’, ‘dateNotEqual’, ‘M3’, ‘valueGreaterThanOrEqual’, ‘captionNotBeginsWith’, ‘dateEqual’, ‘sum’, ‘nextYear’, ‘captionNotEqual’, ‘captionContains’, ‘valueEqual’, ‘thisQuarter’, ‘M9’, ‘dateNewerThan’, ‘M7’, ‘M12’, ‘captionNotContains’, ‘dateNotBetween’, ‘nextWeek’, ‘valueNotBetween’, ‘yesterday’, ‘M2’, ‘captionBetween’, ‘captionNotBetween’, ‘valueBetween’, ‘M4’, ‘Q1’, ‘M5’, ‘dateNewerThanOrEqual’, ‘captionEqual’, ‘valueLessThanOrEqual’, ‘lastWeek’, ‘captionGreaterThanOrEqual’, ‘M10’, ‘Q4’}
- class openpyxl.pivot.table.PivotFilters(count=None, filter=None)[源代码]¶
基类：
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)[源代码]¶
基类：
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)[源代码]¶
基类：
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.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=None, extLst=None)[源代码]¶
基类：
openpyxl.descriptors.serialisable.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¶
Values must be of type <class ‘int’>
- class openpyxl.pivot.table.RowColField(x=None)[源代码]¶
基类：
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=())[源代码]¶
基类：
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 {‘countA’, ‘min’, ‘product’, ‘grand’, ‘sum’, ‘stdDevP’, ‘max’, ‘blank’, ‘data’, ‘varP’, ‘count’, ‘var’, ‘default’, ‘stdDev’, ‘avg’}
- 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=())[源代码]¶
基类：
openpyxl.descriptors.serialisable.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=(), chartFormats=(), pivotHierarchies=(), pivotTableStyleInfo=None, filters=(), rowHierarchiesUsage=None, colHierarchiesUsage=None, extLst=None, id=None)[源代码]¶
基类：
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’>
- 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’>
- 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’>
