編輯

共用方式為


PivotValueCell Interface

Definition

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

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.

Applies to