	Name	Description
	AllSubTotalTop	Indicated whether diplay all subtotal at top of group, Change will cover every field's setting
	AutoFormatType	Gets/sets the auto format type of PivotTable.
	BuiltInStyle	Gets/sets built-in pivot style.
	Cache	Returns cache used by this pivot table. Read-only.
	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.
	CustomTableStyleName	Gets or sets the name of the custom table style for the pivot table.
	DataFields	Gets collection of pivot table data fields. Read-only.
	DisplayErrorString	True if the PivotTable report displays a custom error string in cells that contain errors. The default value is False.
	DisplayFieldCaptions	Gets/sets value controlling whether or not filter buttons and PivotField captions for rows and columns are displayed in the grid.
	DisplayNullString	True if the PivotTable report displays a custom string in cells that contain null values. The default value is True.
	EnableDrilldown	True if drilldown is enabled. The default value is True.
	EnableFieldDialog	True if the PivotTable Field dialog box is available when the user double-clicks the PivotTable field. The default value is True.
	EnableWizard	True if the PivotTable Wizard is available. The default value is True.
	ErrorString	Returns or sets the string displayed in cells that contain errors when the DisplayErrorString property is True.
	FirstDataCol	Specifies the first column of the PivotTable data, relative to the top left cell in the ref value
	FirstDataRow	Specifies the first column of the PivotTable data, relative to the top left cell in the ref value
	FirstHeaderRow	Specifies the first row of the PivotTable header, relative to the top left cell in the ref value.
	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.
	ManualUpdate	True if the PivotTable report is recalculated only at the user's request. The default value is False.
	MergeLabels	True if the specified PivotTable report outer-row item, column item, subtotal, and grand total labels use merged cells.
	Name	Gets pivot table name. Read-only.
	NullString	Returns or sets the string displayed in cells that contain null values when the DisplayNullString property is True.
	Options	Represents the pivot table options.Read-only
	PageFieldOrder	Returns or sets the order in which page fields are added to the PivotTable report layout.
	PageFields	Returns the collection of page field for the specified pivot table,Read-only.
	PageFieldStyle	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).
	PageFieldWrapCount	Returns or sets the number of page fields in each column or row in the PivotTable report.
	Parent	Gets the parent XlsPivotTablesCollection of the current instance.
	PivotConditionalFormats	Returns collection of pivot conditional format. Read-only.
	PivotFields	Gets collection of pivot fields. Read-only.
	ReferenceCount	Get quantity of instance references. (Inherited from XlsObject .)
	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.
	ReportFilters	Gets or sets report filter collection
	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.
	ShowColHeaderStyle	Specifies a boolean value that indicates whether to show column headers for the table.
	ShowColStripes	Specifies a boolean value that indicates whether to show column stripe formatting for the table.
	ShowColumnGrand	Gets/sets value indicating whether the PivotTable contains grand totals for columns.
	ShowDataFieldInRow	Represents the pivot table to add the Calculated Data field in rows
	ShowDrillIndicators	The ShowDrillIndicators property is used for toggling the display of drill indicators in the PivotTable.
	ShowLastCol	Specifies a boolean value that indicates whether to show the last column.
	ShowRowGrand	Gets/sets value indicating whether the PivotTable contains grand totals for rows.
	ShowRowHeaderStyle	Specifies a boolean value that indicates whether to show row headers for the table.
	ShowRowStripes	Specifies a boolean value that indicates whether to show row stripe formatting for the table.
	ShowSubtotals	Gets or sets a value indicating whether subtotals are shown for all fields in the pivot table.
	Workbook	Gets parent workbook. Read-only.
	Worksheet	Gets the worksheet associated with the current instance.

	Name	Description
	AddReference	Increase the quantity of reference. User must use this method when new wrapper on object is created or reference on object stored. (Inherited from XlsObject .)
	ApplyStyleToRange	Apply style to range in pivot table.
	CalculateData	Calculates pivottable's data to cells.
	ChangeDataSource	Change the data source of pivotTable.
	CheckDisposed	Checks whether object was disposed and throws exception if it was. (Inherited from XlsObject .)
	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.
	Clone(Object)	Creates a clone of the specified parent object using the default cache index and no additional parameters.
	Clone(Object, Int32, Dictionary String, String )	Creates a clone of the specified object with additional parameters for caching and worksheet name mapping.
	Dispose	Dispose object and free resources. (Inherited from XlsObject .)
	Equals	Determines whether the specified object is equal to the current object. (Inherited from Object .)
	Finalize	Destructor. Call dispose method of current object. (Inherited from XlsObject .)
	FindParent(Type)	This method is used to find parent with specific type. (Inherited from XlsObject .)
	FindParent( Type )	Find parent of object. (Inherited from XlsObject .)
	FindParent(Type, Boolean)	This method is used to find parent with specific type. (Inherited from XlsObject .)
	FindParents	Finds parent objects. (Inherited from XlsObject .)
	GetHashCode	Serves as the default hash function. (Inherited from Object .)
	GetType	Gets the Type of the current instance. (Inherited from Object .)
	MemberwiseClone	Creates a shallow copy of the current Object . (Inherited from Object .)
	OnDispose	Method which can be overriden by users to take any specific actions when object is disposed. (Inherited from XlsObject .)
	ReleaseReference	Decrease quantity of Reference. User must call this method when freeing resources. (Inherited from XlsObject .)
	SetParent	Sets parent of the object. (Inherited from XlsObject .)
	ToString	Returns a string that represents the current object. (Inherited from Object .)

XlsPivotTable Class

Reference