PivotValueCell 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.
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 PivotValueCellPublic 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. |