NamedRange::PivotCell Property

Gets a PivotCell that represents a cell in a PivotTable report.

Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Syntax

C++

property PivotCell^ PivotCell {
	PivotCell^ get();
}

Property Value

Type: Microsoft.Office.Interop.Excel::PivotCell^

A PivotCell that represents a cell in a PivotTable report.

The following code example creates a PivotTable report and a NamedRange inside the area of the PivotTable report. It then uses the PivotTable, LocationInTable, PivotCell, PivotItem, and PivotField properties to display information about the placement of the NamedRange within the PivotTable report. The example also uses the Group method to perform numeric grouping based on the first value in the field.

This example is for a document-level customization.

C++

No code example is currently available or this language may not be supported.

NamedRange::PivotCell Property

Syntax

Property Value

Examples

See Also