PivotLine interface

Office 2013 and later

A PivotLine object is a line of rows or columns in an Excel PivotTable.

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

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.

A PivotLine contains only visible items, so collapsed children of items and items in hidden levels are not present in the PivotLines collection.

A PivotLine always has a PivotItem in all positions. This means that the PivotLines representing subtotals in the PivotTable contain fewer PivotItems than regular PivotLines.

Show: