PivotTable Class

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

Gets/sets the auto format type of PivotTable.

Gets/sets built-in pivot style.

Returns cache used by this pivot table. Read-only.

Gets Index of the pivot Cache.Read-only.

Returns the collection of calculated fields of the specified pivot table.Read-only.

Returns the collection of Column field for the specified pivot table.Read-only.

Specifies the number of columns per page for this PivotTable that the filter area will occupy.

Gets or sets the name of the custom table style for the pivot table.

Gets collection of pivot table data fields. Read-only.

True if the PivotTable report displays a custom error string in cells that contain errors. The default value is False.

Gets/sets value controlling whether or not filter buttons and PivotField captions for rows and columns are displayed in the grid.

True if the PivotTable report displays a custom string in cells that contain null values. The default value is True.

True if drilldown is enabled. The default value is True.

True if the PivotTable Field dialog box is available when the user double-clicks the PivotTable field. The default value is True.

True if the PivotTable Wizard is available. The default value is True.

Returns or sets the string displayed in cells that contain errors when the DisplayErrorString property is True.

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

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

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

Gets/sets value indicating whether the PivotTable contains column with grand totals for rows (same as ColumnGrand in VBA).

Gets/sets whether compatible with excel2003. The default value is true.

Gets/sets value indicating whether the PivotTable contains row with grand totals for columns (same as RowGrand in VBA).

Returns pivot table location.

True if the PivotTable report is recalculated only at the user's request. The default value is False.

True if the specified PivotTable report outer-row item, column item, subtotal, and grand total labels use merged cells.

Gets pivot table name. Read-only.

Returns or sets the string displayed in cells that contain null values when the DisplayNullString property is True.

Represents the pivot table options.Read-only

Returns or sets the order in which page fields are added to the PivotTable report layout.

Returns the collection of page field for the specified pivot table,Read-only.

Returns or sets the style used in the bound page field area. The default value is a null string (no style is applied by default).

Returns or sets the number of page fields in each column or row in the PivotTable report.

Gets the parent XlsPivotTablesCollection of the current instance.

Returns collection of pivot conditional format. Read-only.

Gets collection of pivot fields. Read-only.

Get quantity of instance references.

True if row, column, and item labels appear on the first row of each page when the specified PivotTable report is printed. False if labels are printed only on the first page. The default value is True.

Gets or sets report filter collection

Returns the collection of Row field for the specified pivot table.Read-only.

Specifies the number of rows per page for this PivotTable that the filter area will occupy.Read-only.

Specifies a boolean value that indicates whether to show column headers for the table.

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

Gets/sets value indicating whether the PivotTable contains grand totals for columns.

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

The ShowDrillIndicators property is used for toggling the display of drill indicators in the PivotTable.

Specifies a boolean value that indicates whether to show the last column.

Gets/sets value indicating whether the PivotTable contains grand totals for rows.

Specifies a boolean value that indicates whether to show row headers for the table.

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

Gets or sets a value indicating whether subtotals are shown for all fields in the pivot table.

Gets parent workbook. Read-only.

Gets the worksheet associated with the current instance.

Increase the quantity of reference. User must use this method when new wrapper on object is created or reference on object stored.

Apply style to range in pivot table.

Calculates pivottable's data to cells.

Change the data source of pivotTable.

Checks whether object was disposed and throws exception if it was.

This method clears all the fields, deletes all filtering and sorting applied to the PivotTable.

clear the column field filter.

clear the row and column field filter depends on field name.

clear the row field filter.

Creates a clone of the specified parent object using the default cache index and no additional parameters.

Creates a clone of the specified object with additional parameters for caching and worksheet name mapping.

Dispose object and free resources.

Determines whether the specified object is equal to the current object.

Destructor. Call dispose method of current object.

This method is used to find parent with specific type.

Find parent of object.

This method is used to find parent with specific type.

Finds parent objects.

Serves as the default hash function.

Gets the Type of the current instance.

Creates a shallow copy of the current Object .

Method which can be overriden by users to take any specific actions when object is disposed.

Decrease quantity of Reference. User must call this method when freeing resources.

Sets parent of the object.

Returns a string that represents the current object.

Flag which indicates if the object was disposed or not.