CalculatedItems.Add(String, String, Object) Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

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.

Creates a new calculated item. Returns a PivotItem object.

public Microsoft.Office.Interop.Excel.PivotItem Add (string Name, string Formula, object UseStandardFormula);

Public Function Add (Name As String, Formula As String, Optional UseStandardFormula As Object) As PivotItem

Parameters

Name: String

Required String. The name of the item.

Formula: String

Required String. The formula for the item.

UseStandardFormula: 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).

Returns

PivotItem

Applies to