PivotField

class PivotField

A source field placed in the Rows, Columns or Filters area of a pivot table, accessed via the PivotFields collections:

>>> pt = xw.books['Book1'].sheets[0].pivot_tables[0]
>>> field = pt.rows.add('Region')
>>> field.name
'Region'
>>> field.parent
<PivotTable 'PivotTable1' in Sheet1>
>>> field.remove()

Added in version 0.37.3.

property api: Any

Returns the native object (pywin32 or appscript obj) of the engine being used.

property name: str

The name of the source field.

property parent: PivotTable

Returns the pivot table the field belongs to.

remove()

Removes the field from its area.