CalculatedItems.Add Method

Creates a new calculated item. Returns a PivotItem 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 PivotItem
'Usage
Dim instance As CalculatedItems
Dim Name As String
Dim Formula As String
Dim UseStandardFormula As Object
Dim returnValue As PivotItem

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

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

Parameters

• Name
  Type: System.String

  Required String. The name of the item.

• Formula
  Type: System.String

  Required String. The formula for the item.

• UseStandardFormula
  Type: System.Object

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

Return Value

Type: Microsoft.Office.Interop.Excel.PivotItem

See Also

Reference

CalculatedItems Interface

CalculatedItems Members

Microsoft.Office.Interop.Excel Namespace