PivotLine PivotLine PivotLine Interface


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

public interface class PivotLine
public interface PivotLine
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.


Application Application Application

When used without an object qualifier, this property returns an _Application object that represents the Microsoft Office Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object. Read-only.

Creator Creator Creator

Returns a 32-bit Integer that indicates the application in which this object was created. Read-only.

LineType LineType LineType

Returns a constant that indicates the type of PivotLine. Read-only.

Parent Parent Parent

Returns the parent object for the specified PivotLine. Read-only.

PivotLineCells PivotLineCells PivotLineCells

Returns a collection of PivotCell objects in a PivotLine. Read-only.

PivotLineCellsFull PivotLineCellsFull PivotLineCellsFull

Retrieves all of the PivotLine cells including those that are hidden in compact form.

Position Position Position

Returns or sets the position of the PivotLine. Read-only.

Applies to