paper-xlsxAPI referencepivot.table
PivotField
paper-xlsx 0.2.1 API reference
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)Attributes
allDrilled
attributeallDrilled= allDrilledautoShow
attributeautoShow= autoShowautoSortScope
attributeautoSortScope= autoSortScopeavgSubtotal
attributeavgSubtotal= avgSubtotalaxis
attributeaxis= axiscompact
attributecompact= compactcountASubtotal
attributecountASubtotal= countASubtotalcountSubtotal
attributecountSubtotal= countSubtotaldataField
attributedataField= dataFielddataSourceSort
attributedataSourceSort= dataSourceSortdefaultAttributeDrillState
attributedefaultAttributeDrillState= defaultAttributeDrillStatedefaultSubtotal
attributedefaultSubtotal= defaultSubtotaldragOff
attributedragOff= dragOffdragToCol
attributedragToCol= dragToColdragToData
attributedragToData= dragToDatadragToPage
attributedragToPage= dragToPagedragToRow
attributedragToRow= dragToRowextLst
attributeextLst= Typed(expected_type=ExtensionList, allow_none=True)hiddenLevel
attributehiddenLevel= hiddenLevelhideNewItems
attributehideNewItems= hideNewItemsidx_base
attributeidx_base= 0includeNewItemsInFilter
attributeincludeNewItemsInFilter= includeNewItemsInFilterinsertBlankRow
attributeinsertBlankRow= insertBlankRowinsertPageBreak
attributeinsertPageBreak= insertPageBreakitemPageCount
attributeitemPageCount= itemPageCountitems
attributeitems= itemsmaxSubtotal
attributemaxSubtotal= maxSubtotalmeasureFilter
attributemeasureFilter= measureFilterminSubtotal
attributeminSubtotal= minSubtotalmultipleItemSelectionAllowed
attributemultipleItemSelectionAllowed= multipleItemSelectionAllowedname
attributename= namenamespace
attributenamespace= NonenonAutoSortDefault
attributenonAutoSortDefault= nonAutoSortDefaultnumFmtId
attributenumFmtId= numFmtIdoutline
attributeoutline= outlineproductSubtotal
attributeproductSubtotal= productSubtotalrankBy
attributerankBy= rankByserverField
attributeserverField= serverFieldshowAll
attributeshowAll= showAllshowDropDowns
attributeshowDropDowns= showDropDownsshowPropAsCaption
attributeshowPropAsCaption= showPropAsCaptionshowPropCell
attributeshowPropCell= showPropCellshowPropTip
attributeshowPropTip= showPropTipsortType
attributesortType= sortTypestdDevPSubtotal
attributestdDevPSubtotal= stdDevPSubtotalstdDevSubtotal
attributestdDevSubtotal= stdDevSubtotalsubtotalCaption
attributesubtotalCaption= subtotalCaptionsubtotalTop
attributesubtotalTop= subtotalTopsumSubtotal
attributesumSubtotal= sumSubtotaltagname
attributetagname= 'pivotField'topAutoShow
attributetopAutoShow= topAutoShowuniqueMemberProperty
attributeuniqueMemberProperty= uniqueMemberPropertyvarPSubtotal
attributevarPSubtotal= varPSubtotalvarSubtotal
attributevarSubtotal= varSubtotalFunctions
__iter__
func__iter__()from_tree
funcfrom_tree(node)Create object from XML
paramnodeto_tree
functo_tree(tagname=None, idx=None, namespace=None)paramtagname= Noneparamidx= Noneparamnamespace= None