Range.LocationInTable Property

Returns a constant that describes the part of the PivotTable report that contains the upper-left corner of the specified range.

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

XlLocationInTable LocationInTable { get; }

XlLocationInTable can be one of the following XlLocationInTable constants:

  • xlRowHeader

  • xlColumnHeader

  • xlPageHeader

  • xlDataHeader

  • xlRowItem

  • xlColumnItem

  • xlPageItem

  • xlDataItem

  • xlTableBody

Show: