[]
        
(Showing Draft Content)

GrapeCity.Documents.Excel.IPivotCell

IPivotCell Interface

Represents a cell in a PivotTable report.

Namespace: GrapeCity.Documents.Excel
Assembly: DS.Documents.Excel.dll
Syntax
public interface IPivotCell
Public Interface IPivotCell

Properties

Name Description
ColumnItems

Returns a PivotItemList collection that corresponds to the items on the column axis that represent the selected range.

CustomSubtotalFunction

Returns the custom subtotal function field setting of a PivotCell object.

DataField

Returns a PivotField object that corresponds to the selected data field.

PivotCellType

Returns a constant that identifies the PivotTable entity the cell corresponds to.

PivotColumnLine

Returns the PivotLine on a column for a specific PivotCell object.

PivotField

Returns a PivotField object that represents the PivotTable field containing the upper-left corner of the specified range.

PivotItem

Returns a PivotItem object that represents the PivotTable item containing the upper-left corner of the specified range.

PivotRowLine

Returns the PivotLine on a row for a specific PivotCell object.

PivotTable

Returns a PivotTable object that represents the PivotTable report containing the upper-left corner of the specified range, or the PivotTable report associated with the PivotChart report.

Range

Returns a Range object that represents the range the specified PivotCell applies to.

RowItems

Returns a PivotItemList collection that corresponds to the items on the category axis that represent the selected cell.