PivotValueCell PivotValueCell PivotValueCell Interface


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

public interface class PivotValueCell
public interface PivotValueCell
Public Interface PivotValueCell


Application Application Application

Returns an Application Application object that represents the Excel application. Read-only.

Creator Creator Creator

Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Integer (int in C#).

Parent Parent Parent

Returns an Object (object in C#) that represents the parent object of the specified PivotValueCell object. Read-only.

PivotCell PivotCell PivotCell

Returns the PivotCell that specifies the location of the PivotValueCell. Read-only

ServerActions ServerActions ServerActions

Returns a collection of OLAP Action name objects which will represent OLAP-defined actions which can be executed. Read-only

Value Value 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.


ShowDetail() ShowDetail() ShowDetail()

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

Applies to