paper-xlsxAPI referencepivot.table
TableDefinition
paper-xlsx 0.2.1 API reference
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)Attributes
applyAlignmentFormats
attributeapplyAlignmentFormats= applyAlignmentFormatsapplyBorderFormats
attributeapplyBorderFormats= applyBorderFormatsapplyFontFormats
attributeapplyFontFormats= applyFontFormatsapplyNumberFormats
attributeapplyNumberFormats= applyNumberFormatsapplyPatternFormats
attributeapplyPatternFormats= applyPatternFormatsapplyWidthHeightFormats
attributeapplyWidthHeightFormats= applyWidthHeightFormatsasteriskTotals
attributeasteriskTotals= asteriskTotalsautoFormatId
attributeautoFormatId= autoFormatIdcache
attributecache= NonecacheId
attributecacheId= cacheIdchartFormat
attributechartFormat= chartFormatchartFormats
attributechartFormats= chartFormatscolFields
attributecolFields= colFieldscolGrandTotals
attributecolGrandTotals= colGrandTotalscolHeaderCaption
attributecolHeaderCaption= colHeaderCaptioncolHierarchiesUsage
attributecolHierarchiesUsage= colHierarchiesUsagecolItems
attributecolItems= colItemscompact
attributecompact= compactcompactData
attributecompactData= compactDataconditionalFormats
attributeconditionalFormats= NonecreatedVersion
attributecreatedVersion= createdVersioncustomListSort
attributecustomListSort= customListSortdataCaption
attributedataCaption= dataCaptiondataFields
attributedataFields= dataFieldsdataOnRows
attributedataOnRows= dataOnRowsdataPosition
attributedataPosition= dataPositiondisableFieldList
attributedisableFieldList= disableFieldListeditData
attributeeditData= editDataenableDrill
attributeenableDrill= enableDrillenableFieldProperties
attributeenableFieldProperties= enableFieldPropertiesenableWizard
attributeenableWizard= enableWizarderrorCaption
attributeerrorCaption= errorCaptionextLst
attributeextLst= extLstfieldListSortAscending
attributefieldListSortAscending= fieldListSortAscendingfieldPrintTitles
attributefieldPrintTitles= fieldPrintTitlesfilters
attributefilters= filtersformats
attributeformats= formatsgrandTotalCaption
attributegrandTotalCaption= grandTotalCaptiongridDropZones
attributegridDropZones= gridDropZonesid
attributeid= ididx_base
attributeidx_base= 0immersive
attributeimmersive= immersiveindent
attributeindent= indentitemPrintTitles
attributeitemPrintTitles= itemPrintTitleslocation
attributelocation= locationmdxSubqueries
attributemdxSubqueries= mdxSubqueriesmergeItem
attributemergeItem= mergeItemmime_type
attributemime_type= 'application/vnd.openxmlformats-officedocument.spreadsheetml.pivotTable+xml'minRefreshableVersion
attributeminRefreshableVersion= minRefreshableVersionmissingCaption
attributemissingCaption= missingCaptionmultipleFieldFilters
attributemultipleFieldFilters= multipleFieldFiltersname
attributename= namenamespace
attributenamespace= Noneoutline
attributeoutline= outlineoutlineData
attributeoutlineData= outlineDatapageFields
attributepageFields= pageFieldspageOverThenDown
attributepageOverThenDown= pageOverThenDownpageStyle
attributepageStyle= pageStylepageWrap
attributepageWrap= pageWrappath
attributepathpivotFields
attributepivotFields= pivotFieldspivotHierarchies
attributepivotHierarchies= pivotHierarchiespivotTableStyle
attributepivotTableStyle= pivotTableStylepivotTableStyleInfo
attributepivotTableStyleInfo= pivotTableStyleInfopreserveFormatting
attributepreserveFormatting= preserveFormattingprintDrill
attributeprintDrill= printDrillpublished
attributepublished= publishedrel_type
attributerel_type= 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/pivotTable'rowFields
attributerowFields= rowFieldsrowGrandTotals
attributerowGrandTotals= rowGrandTotalsrowHeaderCaption
attributerowHeaderCaption= rowHeaderCaptionrowHierarchiesUsage
attributerowHierarchiesUsage= rowHierarchiesUsagerowItems
attributerowItems= rowItemsshowCalcMbrs
attributeshowCalcMbrs= showCalcMbrsshowDataDropDown
attributeshowDataDropDown= showDataDropDownshowDataTips
attributeshowDataTips= showDataTipsshowDrill
attributeshowDrill= showDrillshowDropZones
attributeshowDropZones= showDropZonesshowEmptyCol
attributeshowEmptyCol= showEmptyColshowEmptyRow
attributeshowEmptyRow= showEmptyRowshowError
attributeshowError= showErrorshowHeaders
attributeshowHeaders= showHeadersshowItems
attributeshowItems= showItemsshowMemberPropertyTips
attributeshowMemberPropertyTips= showMemberPropertyTipsshowMissing
attributeshowMissing= showMissingshowMultipleLabel
attributeshowMultipleLabel= showMultipleLabelsubtotalHiddenItems
attributesubtotalHiddenItems= subtotalHiddenItemssummary
attributesummaryProvide a simplified summary of the table
tag
attributetag= tagtagname
attributetagname= 'pivotTableDefinition'updatedVersion
attributeupdatedVersion= updatedVersionuseAutoFormatting
attributeuseAutoFormatting= useAutoFormattingvacatedStyle
attributevacatedStyle= vacatedStylevisualTotals
attributevisualTotals= visualTotalsFunctions
__iter__
func__iter__()formatted_fields
funcformatted_fields()Map fields to associated conditional formats by priority
from_tree
funcfrom_tree(node)Create object from XML
paramnodeto_tree
functo_tree()