Compartilhar via

CalculatedFields.Add Method

  • Artigo

Creates a new calculated field. Returns a PivotField object.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function Add ( _
    Name As String, _
    Formula As String, _
    UseStandardFormula As Object _
) As PivotField
'Usage
Dim instance As CalculatedFields
Dim Name As String
Dim Formula As String
Dim UseStandardFormula As Object
Dim returnValue As PivotField

returnValue = instance.Add(Name, Formula, _
    UseStandardFormula)

PivotField Add(
    string Name,
    string Formula,
    Object UseStandardFormula
)

Parameters

  • Name
    Type: System.String

    Required String. The name of the field.

  • Formula
    Type: System.String

    Required String. The formula for the field.

  • UseStandardFormula
    Type: System.Object

    Optional Object. False (default) for upward compatibility. True for strings contained in any arguments that are field names (will be interpreted as having been formatted in standard U.S. English instead of local settings).

Return Value

Type: Microsoft.Office.Interop.Excel.PivotField

See Also

Reference

CalculatedFields Interface

CalculatedFields Members

Microsoft.Office.Interop.Excel Namespace