Document Solutions for Excel, .NET Edition | Document Solutions
GrapeCity.Documents.Excel Namespace / IPivotTable Interface
Properties Methods

In This Topic
    IPivotTable Interface Members
    In This Topic

    The following tables list the members exposed by IPivotTable.

    Public Properties
     NameDescription
    PropertyAllowMultipleFilters Gets or sets a value that indicates whether a PivotField can have multiple filters applied to it at the same time.  
    PropertyCalculatedFieldsReturns an ICalculatedFields collection that represents all the calculated fields in the specified PivotTable report.  
    PropertyColumnFieldsReturns an object that represents a collection of all the fields (an IPivotFields object) that are currently shown as column fields. Read-only.  
    PropertyColumnGrand Gets or sets whether the PivotTable report shows grand totals for columns (read or write).  
    PropertyColumnRange Returns a Range object that represents the range that contains the column area in the PivotTable report (read-only).  
    PropertyCompactRowIndent Returns or sets the indent increment for PivotItems when compact row layout form is turned on. Read/write.  
    PropertyDataBodyRange Returns a Range object that represents the range that contains the data area in the list between the header row and the insert row (read-only).  
    PropertyDataFieldsReturns an object that represents a collection of all the fields (an IPivotFields object) that are currently shown as data fields. Read-only.  
    PropertyDeferLayoutUpdate Returns or sets whether the pivotTable defer layout update.  
    PropertyDisplayContextTooltips Gets or sets whether tooltips are displayed for PivotTable cells (read or write).  
    PropertyDisplayErrorString True if the PivotTable report displays a custom error string in cells that contain errors. The default value is False.  
    PropertyDisplayMemberPropertyTooltips Gets or sets whether to display member properties in tooltips.  
    PropertyDisplayNullString True if the PivotTable report displays a custom string in cells that contain null values. The default value is True.  
    PropertyErrorString Returns or sets the string displayed in cells that contain errors when the PivotTable.DisplayErrorString property is True. The default value is an empty string (""). Read/write String.  
    PropertyGrandTotalName Gets or sets the text string label that is displayed in the grand total column or row heading in the specified PivotTable report. The default value is the string "Grand Total".  
    PropertyLayoutRowDefault This property specifies the layout settings for PivotFields when they are added to the PivotTable for the first time.  
    PropertyMergeLabels True if the specified PivotTable report’s outer-row item, column item, subtotal, and grand total labels use merged cells.  
    PropertyName Gets or sets the name of the object.  
    PropertyNullString Returns or sets the string displayed in cells that contain null values when the PivotTable.DisplayNullString property is True. The default value is an empty string ("").  
    PropertyPageFieldOrder Returns or sets the order in which page fields are added to the PivotTable report’s layout. Can be one of the following Order constants: DownThenOver or OverThenDown. The default constant is DownThenOver.  
    PropertyPageFieldsReturns an object that represents a collection of all the fields (an IPivotFields object) that are currently showing as page fields. Read-only.  
    PropertyPageFieldWrapCount Returns or sets the number of page fields in each column or row in the PivotTable report.  
    PropertyPageRange Returns a Range object that represents the range that contains the page area in the PivotTable report.  
    PropertyPivotCache Returns a PivotCache object that represents the cache for the specified PivotTable report.  
    PropertyPivotColumnAxis Returns a PivotAxis object representing the entire column axis.  
    PropertyPivotFields Returns an object that represents either a single PivotTable field (a PivotField object) or a collection of both the visible and hidden fields (a PivotFields object) in the PivotTable report.  
    PropertyPivotFormulas Returns a PivotFormulas object that represents the collection of formulas for the specified PivotTable report.  
    PropertyPivotRowAxis Returns a PivotAxis object representing the entire row axis.  
    PropertyRowFieldsReturns an object that represents either a collection of all the fields (an IPivotFields object) that are currently showing as row fields. Read-only.  
    PropertyRowGrand Gets or sets whether the PivotTable report shows grand totals for rows.  
    PropertyRowRange Returns a Range object that represents the range including the row area on the PivotTable report.  
    PropertyShowTableStyleColumnHeaders The PivotTable.ShowTableStyleColumnHeadersproperty is set to True if the coulmn headers should be displayed in the PivotTable.  
    PropertyShowTableStyleColumnStripes The Boolean property displays banded columns in which even columns are formatted differently from odd columns. This makes PivotTableseasier to read.  
    PropertyShowTableStyleLastColumn The Boolean property displays grand total columns style.  
    PropertyShowTableStyleRowHeaders The PivotTable.ShowTableStyleRowHeaders property is set to True if the row headers should be displayed in the PivotTable.  
    PropertyShowTableStyleRowStripes The PivotTable.ShowTableStyleRowStripes property displays banded rows in which even rows are formatted differently from odd rows. This makes PivotTables easier to read.  
    PropertyStyle Gets or sets the style currently applied to the specified pivot table.  
    PropertyTableRange1 Returns a Range object that represents the range containing the entire PivotTable report, but doesn’t include page fields.  
    PropertyTableRange2 Returns a Range object that represents the range containing the entire PivotTable report, including page fields.  
    PropertyTableStyle Gets or sets the style used in the body of the PivotTable report. The default value is a null string (no style is applied by default).  
    PropertyTag Gets or sets a string saved with the PivotTable report.  
    Top
    Public Methods
     NameDescription
    MethodAddDataField Adds a data field to a PivotTable report. Returns a PivotField object that represents the new data field.  
    MethodClearAllFilters Deletes all filters currently applied to the PivotTable. This includes deleting all filters in the PivotFilters collection of the PivotTable object, removing any manual filtering applied, and setting all PivotFields in the Report Filter area to the default item.  
    MethodClearTable Clears a PivotTable. Clearing PivotTables includes removing all the fields and deleting all filtering and sorting applied to the PivotTables. This method resets the PivotTable to the state it had right after it was created, before any fields were added to it.  
    MethodPivotValueCell Retrieve the PivotValueCell object for a given PivotTable provided certain row and column indices.  
    MethodRefresh Refreshes the PivotTable report from the source data. Returns True if it’s successful.  
    MethodRepeatAllLabels Sets whether to repeat item labels for all PivotFields in the specified PivotTable.  
    MethodSetRowAxisLayout This method is used for simultaneously setting layout options for all existing PivotFields.  
    MethodSubtotalLocation Changes the subtotal location for all existing PivotFields. Changing the subtotal location has an immediate visual effect only for fields in outline form, but it will be set for fields in tabular form as well.  
    MethodUpdate Updates the link or PivotTable report.  
    Top
    See Also

    Reference

    IPivotTable Interface
    GrapeCity.Documents.Excel Namespace