CalculatedItems.Add(String, String, Object) Method
Definition
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 PivotItemParameters
- 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).