Syncfusion.XlsIO.Base
Properties  Methods 

Syncfusion.XlsIO Namespace : IPivotTable Interface

IPivotTable Interface Members

The following tables list the members exposed by IPivotTable.

Public Properties
 NameDescription
 PropertyGets or sets the PivotBuiltInStyles of the pivot table.  
 Property Gets the index number of the PivotTable cache. Read-only.  
 PropertyGets the collection of IPivotCalculatedFields in the pivot table. Read-only.  
 PropertyGets the collection of IPivotFields in the pivot table. Read-only.  
 Property Gets or sets value indicating whether the PivotTable contains column with grand totals for rows (same as ColumnGrand in VBA). Default value is true.  
 Property Gets the number of columns per page for this PivotTable that the filter area will occupy. Read-only.  
 PropertyGets the collection of IPivotDataFields in pivot table. Read-only.  
 Property Gets or sets a Boolean value indicating whether filter buttons and pivot field captions for rows and columns are displayed in the grid. The default value is True.  
 PropertyGets the collection of IPivotFields. Read-only.  
 PropertyGets or sets IRange of pivot table location in the worksheet.  
 Property Gets or sets the pivot table name. This property allows you to Read and Write a pivot table name.  
 PropertyGets the IPivotTableOptions of pivot table. Read-only.  
 PropertyGets the collection of IPivotFields in the pivot table. Read-only.  
 PropertyGets or sets the Syncfusion.XlsIO.Implementation.PivotAnalysis.PivotEngine of the pivot table.  
 Property Gets or sets a Boolean value indicating whether labels must be repeated on every page.The default value is True.  
 PropertyGets the collection of IPivotFields in the pivot table. Read-only.  
 Property Gets or sets value indicating whether the PivotTable contains row with grand totals for columns (same as RowGrand in VBA). Default value is true.  
 Property Gets the number of rows per page for this PivotTable that the filter area will occupy. Read-only.  
 Property Gets or sets a Boolean value indicating whether the PivotTable contains grand totals for columns.  
 Property Gets or sets a Boolean value indicating whether the PivotTable data fields are shown in rows.  
 Property Gets or sets a Boolean value indicating whether to toggle the display of drill indicators in the PivotTable. Default value is true.  
 Property Gets or sets a Boolean value indicating whether the PivotTable contains grand totals for rows.  
Top
Public Methods
 NameDescription
 Method Clears all the fields, deletes all filtering and sorting applied to the PivotTable.  
 Method Draws a layout for the pivot table.  
Top
See Also