Name | Description | |
---|---|---|
![]() | getColumnItems | Returns a PivotItemList collection that corresponds to the items on the column axis that represent the selected range. |
![]() | getCustomSubtotalFunction | Returns the custom subtotal function field setting of a PivotCell object. |
![]() | getDataField | Returns a PivotField object that corresponds to the selected data field. |
![]() | getPivotCellType | Returns a constant that identifies the PivotTable entity the cell corresponds to. |
![]() | getPivotColumnLine | Returns the PivotLine on a column for a specific PivotCell object. |
![]() | getPivotField | Returns a PivotField object that represents the PivotTable field containing the upper-left corner of the specified range. |
![]() | getPivotItem | Returns a PivotItem object that represents the PivotTable item containing the upper-left corner of the specified range. |
![]() | getPivotRowLine | Returns the PivotLine on a row for a specific PivotCell object. |
![]() | getPivotTable | 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. |
![]() | getRange | Returns a Range object that represents the range the specified PivotCell applies to. |
![]() | getRowItems | Returns a PivotItemList collection that corresponds to the items on the category axis that represent the selected cell. |