CalculatedFields.Add Method

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