Paper Office
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
= allDrilled

autoShow

attributeautoShow
= autoShow

autoSortScope

attributeautoSortScope
= autoSortScope

avgSubtotal

attributeavgSubtotal
= avgSubtotal

axis

attributeaxis
= axis

compact

attributecompact
= compact

countASubtotal

attributecountASubtotal
= countASubtotal

countSubtotal

attributecountSubtotal
= countSubtotal

dataField

attributedataField
= dataField

dataSourceSort

attributedataSourceSort
= dataSourceSort

defaultAttributeDrillState

attributedefaultAttributeDrillState
= defaultAttributeDrillState

defaultSubtotal

attributedefaultSubtotal
= defaultSubtotal

dragOff

attributedragOff
= dragOff

dragToCol

attributedragToCol
= dragToCol

dragToData

attributedragToData
= dragToData

dragToPage

attributedragToPage
= dragToPage

dragToRow

attributedragToRow
= dragToRow

extLst

attributeextLst
= Typed(expected_type=ExtensionList, allow_none=True)

hiddenLevel

attributehiddenLevel
= hiddenLevel

hideNewItems

attributehideNewItems
= hideNewItems

idx_base

attributeidx_base
= 0

includeNewItemsInFilter

attributeincludeNewItemsInFilter
= includeNewItemsInFilter

insertBlankRow

attributeinsertBlankRow
= insertBlankRow

insertPageBreak

attributeinsertPageBreak
= insertPageBreak

itemPageCount

attributeitemPageCount
= itemPageCount

items

attributeitems
= items

maxSubtotal

attributemaxSubtotal
= maxSubtotal

measureFilter

attributemeasureFilter
= measureFilter

minSubtotal

attributeminSubtotal
= minSubtotal

multipleItemSelectionAllowed

attributemultipleItemSelectionAllowed
= multipleItemSelectionAllowed

name

attributename
= name

namespace

attributenamespace
= None

nonAutoSortDefault

attributenonAutoSortDefault
= nonAutoSortDefault

numFmtId

attributenumFmtId
= numFmtId

outline

attributeoutline
= outline

productSubtotal

attributeproductSubtotal
= productSubtotal

rankBy

attributerankBy
= rankBy

serverField

attributeserverField
= serverField

showAll

attributeshowAll
= showAll

showDropDowns

attributeshowDropDowns
= showDropDowns

showPropAsCaption

attributeshowPropAsCaption
= showPropAsCaption

showPropCell

attributeshowPropCell
= showPropCell

showPropTip

attributeshowPropTip
= showPropTip

sortType

attributesortType
= sortType

stdDevPSubtotal

attributestdDevPSubtotal
= stdDevPSubtotal

stdDevSubtotal

attributestdDevSubtotal
= stdDevSubtotal

subtotalCaption

attributesubtotalCaption
= subtotalCaption

subtotalTop

attributesubtotalTop
= subtotalTop

sumSubtotal

attributesumSubtotal
= sumSubtotal

tagname

attributetagname
= 'pivotField'

topAutoShow

attributetopAutoShow
= topAutoShow

uniqueMemberProperty

attributeuniqueMemberProperty
= uniqueMemberProperty

varPSubtotal

attributevarPSubtotal
= varPSubtotal

varSubtotal

attributevarSubtotal
= varSubtotal

Functions

__iter__

func__iter__()

from_tree

funcfrom_tree(node)

Create object from XML

paramnode

to_tree

functo_tree(tagname=None, idx=None, namespace=None)
paramtagname
= None
paramidx
= None
paramnamespace
= None

On this page