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)

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.