IPivotTable Interface |
Represents pivot table object.
Namespace: Spire.Xls.Core
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
The IPivotTable type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
|
AutoFormatType |
Gets/sets the auto format type of PivotTable.
|
|
|
BuiltInStyle |
Gets/sets built-in pivot style.
|
|
|
CacheIndex |
Gets Index of the pivot Cache.Read-only.
|
|
|
CalculatedFields |
Returns the collection of calculated fields of the specified pivot table.Read-only.
|
|
|
ColumnFields |
Returns the collection of Column field for the specified pivot table.Read-only.
|
|
|
ColumnsPerPage |
Specifies the number of columns per page for this PivotTable that the filter area will occupy.
|
|
|
DataFields |
Gets collection of pivot table data fields. Read-only.
|
|
|
DisplayFieldCaptions |
Gets/sets value controlling whether or not filter buttons and PivotField
captions for rows and columns are displayed in the grid.
|
|
|
IsColumnGrand |
Gets/sets value indicating whether the PivotTable contains column with grand totals for rows (same as ColumnGrand in VBA).
|
|
|
IsCompatibleWithExcel2003 |
Gets/sets whether compatible with excel2003. The default value is true.
|
|
|
IsRowGrand |
Gets/sets value indicating whether the PivotTable contains row with grand totals for columns (same as RowGrand in VBA).
|
|
|
Location |
Returns pivot table location.
|
|
|
Name |
Gets pivot table name. Read-only.
|
|
|
Options |
Represents the pivot table options.Read-only
|
|
|
PageFields |
Returns the collection of page field for the specified pivot table,Read-only.
|
|
|
PivotFields |
Gets collection of pivot fields. Read-only.
|
|
|
RepeatItemsOnEachPrintedPage |
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.
|
|
|
RowFields |
Returns the collection of Row field for the specified pivot table.Read-only.
|
|
|
RowsPerPage |
Specifies the number of rows per page for this PivotTable that the filter area will occupy.Read-only.
|
|
|
ShowColumnGrand |
Gets/sets value indicating whether the PivotTable contains grand totals for columns.
|
|
|
ShowDataFieldInRow |
Gets/sets value indicating whether the PivotTable data fields are shown in rows.
|
|
|
ShowDrillIndicators |
The ShowDrillIndicators property is used for toggling the display of
drill indicators in the PivotTable.
|
|
|
ShowRowGrand |
Gets/sets value indicating whether the PivotTable contains grand totals for rows.
|
Methods
| Name | Description | |
|---|---|---|
|
ApplyStyleToRange |
Apply style to range in pivot table.
|
|
|
ChangeDataSource |
Change the data source of pivotTable.
|
|
|
Clear |
This method clears all the fields, deletes all filtering and sorting applied to the PivotTable.
|
|
|
ClearColumnFieldFilter |
clear the column field filter.
|
|
|
ClearFilter |
clear the row and column field filter depends on field name.
|
|
|
ClearRowFieldFilter |
clear the row field filter.
|
See Also
