XlsPivotTable module

class XlsPivotTable.XlsPivotTable

Bases: XlsObject, IPivotTable

property AllSubTotalTop: bool

<summary>

Indicated whether diplay all subtotal at top of group,: Change will cover every field’s setting

</summary>

property AutoFormatType: PivotAutoFomatTypes

property BuiltInStyle: PivotBuiltInStyles

property Cache: PivotCache

property CacheIndex: int

CalculateData()

property CalculatedFields: IPivotCalculatedFields

ChangeDataSource(dataSource: IXLSRange)

<summary>: Change the data source of pivotTable.

</summary> <param name=”dataSource”>New data source range.</param>

Clear()

ClearColumnFieldFilter(fieldName: str)

ClearFilter(fieldName: str)

ClearRowFieldFilter(fieldName: str)

Clone

property ColumnFields: IPivotFields

property ColumnsPerPage: int

property CustomTableStyleName: str

<summary>: Represent the custom Style for this PivotTable

</summary>

property DataFields: PivotDataFields

property DisplayErrorString: bool

property DisplayFieldCaptions: bool

property DisplayNullString: bool

property EnableDrilldown: bool

property EnableFieldDialog: bool

property EnableWizard: bool

property ErrorString: str

property FirstDataCol: int

<summary>

Specifies the first column of the PivotTable data, relative to the top left cell in the ref: value

</summary>

property FirstDataRow: int

<summary>

Specifies the first column of the PivotTable data, relative to the top left cell in the ref: value

</summary>

property FirstHeaderRow: int

<summary>

Specifies the first row of the PivotTable header, relative to the top left cell in the ref: value.

</summary>

property IsColumnGrand: bool

property IsCompatibleWithExcel2003: bool

property IsRowGrand: bool

property Location: CellRange

property ManualUpdate: bool

property MergeLabels: bool

property Name: str

property NullString: str

property Options: IPivotTableOptions

property PageFieldOrder: PagesOrderType

property PageFieldStyle: str

property PageFieldWrapCount: int

property PageFields: IPivotFields

property Parent: XlsPivotTablesCollection

property PivotConditionalFormats: PivotConditionalFormatCollection

property PivotFields: PivotTableFields

property RepeatItemsOnEachPrintedPage: bool

property ReportFilters: PivotReportFilters

<summary>: Gets or sets report filter collection

</summary>

property RowFields: IPivotFields

property RowsPerPage: int

property ShowColHeaderStyle: bool

<summary>: Specifies a boolean value that indicates whether to show column headers for the table.

</summary>

property ShowColStripes: bool

<summary>

Specifies a boolean value that indicates whether to show column stripe formatting for: the table.

</summary>

property ShowColumnGrand: bool

property ShowDataFieldInRow: bool

<summary>

Represents the pivot table to add the Calculated: Data field in rows

</summary>

property ShowDrillIndicators: bool

property ShowLastCol: bool

<summary>: Specifies a boolean value that indicates whether to show the last column.

</summary>

property ShowRowGrand: bool

property ShowRowHeaderStyle: bool

<summary>: Specifies a boolean value that indicates whether to show row headers for the table.

</summary>

property ShowRowStripes: bool

<summary>

Specifies a boolean value that indicates whether to show row stripe formatting for the: table.

</summary>

property ShowSubtotals: bool

property Workbook: XlsWorkbook

property Worksheet: XlsWorksheet