Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here.

XlLocationInTable Enumeration 

Specifies the part of the PivotTable report that contains the upper-left corner of a range.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

Dim xlLocationInTable1 As XlLocationInTable = XlLocationInTable.xlColumnHeader

public enum XlLocationInTable
public enum XlLocationInTable
public enum XlLocationInTable

Member nameDescription
xlColumnHeaderColumn header.
xlColumnItemColumn item.
xlDataHeaderData header.
xlDataItemData item.
xlPageHeaderPage header.
xlPageItemPage item.
xlRowHeaderRow header.
xlRowItemRow item.
xlTableBodyTable body.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

Community Additions

© 2015 Microsoft