NamedRange::LocationInTable Property

 

Gets a constant that describes the part of the PivotTable report that contains the upper-left corner of the NamedRange control.

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

C#
C++
F#
VB
Copy 
property XlLocationInTable LocationInTable {
	XlLocationInTable get();
}

Property Value

Type: Microsoft.Office.Interop.Excel::XlLocationInTable

One of the XlLocationInTable values.

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#
VB
C++
Copy
No code example is currently available or this language may not be supported.
Return to top
Show: