IPivotTable module

class IPivotTable.IPivotTable

Bases: ABC

abstract property AutoFormatType: PivotAutoFomatTypes

abstract property BuiltInStyle: BuiltInStyles

abstract property CacheIndex: int

abstract property CalculatedFields: IPivotCalculatedFields

abstract ChangeDataSource(dataSource: IXLSRange)

abstract Clear()

abstract ClearColumnFieldFilter(fieldName: str)

abstract ClearFilter(fieldName: str)

abstract ClearRowFieldFilter(fieldName: str)

abstract property ColumnFields: IPivotFields

abstract property ColumnsPerPage: int

abstract property DataFields: PivotDataFields

abstract property DisplayFieldCaptions: bool

abstract property IsColumnGrand: bool

abstract property IsCompatibleWithExcel2003: bool

abstract property IsRowGrand: bool

abstract property Location: CellRange

abstract property Name: str

abstract property Options: IPivotTableOptions

abstract property PageFields: IPivotFields

abstract property PivotFields: PivotTableFields

abstract property RepeatItemsOnEachPrintedPage: bool

abstract property RowFields: IPivotFields

abstract property RowsPerPage: int

abstract property ShowColumnGrand: bool

abstract property ShowDataFieldInRow: bool

abstract property ShowDrillIndicators: bool

abstract property ShowRowGrand: bool