PivotLine Interface

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)

[InterfaceTypeAttribute()]
[GuidAttribute("00024480-0000-0000-C000-000000000046")]
public interface PivotLine

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: