PivotLine Interface
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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 PivotLinePublic 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. |