編輯

共用方式為


PivotFormula Interface

Definition

Represents a formula used to calculate results in a PivotTable report.

public interface class PivotFormula
[System.Runtime.InteropServices.Guid("0002441E-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface PivotFormula
Public Interface PivotFormula
Attributes

Remarks

Use PivotFormulas(index), where index is the formula number or string on the left side of the formula, to return the PivotFormula object.

This object and its associated properties and methods aren’t available for OLAP data sources because calculated fields and items aren’t supported.

Properties

_Default

Reserved for internal use.

Application

Returns an Application object that represents the Microsoft Excel application.

Creator

Returns a 32-bit integer that indicates the application in which this object was created.

Formula

Returns or sets the object's formula in A1-style notation.

Index

Returns or sets the index number of the object within the PivotFormulas collection.

Parent

Returns the parent object for the specified object.

StandardFormula

Returns or sets a String specifying formulas with standard English (United States) formatting.

Value

The name of the specified formula in the PivotTable formula.

Methods

Delete()

Deletes the object.

Applies to