PivotLine Interface

Definition

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

public interface class PivotLine
[System.Runtime.InteropServices.Guid("00024480-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface PivotLine
Public Interface PivotLine
Attributes

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.

Properties

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

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

LineType

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

Parent

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

PivotLineCells

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

PivotLineCellsFull

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

Position

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

Applies to