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)
Syntax
'Declaration
<InterfaceTypeAttribute()> _
<GuidAttribute("00024480-0000-0000-C000-000000000046")> _
Public Interface PivotLine
'Usage
Dim instance As PivotLine
[InterfaceTypeAttribute()]
[GuidAttribute("00024480-0000-0000-C000-000000000046")]
public interface PivotLine
Remarks
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.