CalculatedFields.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 field. Returns a PivotField object.

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

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

Parameters

Name: String

Required String. The name of the field.

Formula: String

Required String. The formula for the field.

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

Returns

PivotField

Applies to