PivotValueCell Interface

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

Provides a way to expose values of cells in the case that actual cells (Range objects) are not available.

public interface class PivotValueCell

[System.Runtime.InteropServices.Guid("000244CF-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface PivotValueCell

Public Interface PivotValueCell

Attributes

GuidAttribute InterfaceTypeAttribute

Properties

Application	Returns an Application Application object that represents the Excel application. Read-only.
Creator	Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Integer (int in C#).
Parent	Returns an Object (object in C#) that represents the parent object of the specified PivotValueCell object. Read-only.
PivotCell	Returns the PivotCell that specifies the location of the PivotValueCell. Read-only
ServerActions	Returns a collection of OLAP Action name objects which will represent OLAP-defined actions which can be executed. Read-only
Value	Returns the value at the location. The value is the value after ShowAs and other calculations have been applied. Variant can be Empty, Number, Date, String, or Error value.

Methods

ShowDetail()

Puts the individual rows of an OLAP data source which contribute to an aggregate onto their own Excel worksheet.