GrapeCity.Documents.Excel.ICalculatedFields

Interface ICalculatedFields

Namespace

GrapeCity.Documents.Excel

Assembly

GcDocs.Excel.dll

A collection of IPivotField objects that represents all the calculated fields in the specified PivotTable report.

public interface ICalculatedFields : IEnumerable<IPivotField>, IEnumerable

Inherited Members

System.Collections.Generic.IEnumerable<GrapeCity.Documents.Excel.IPivotField>.GetEnumerator()

Properties

Count

Returns the number of calculated fields.

int Count { get; }

Property Value

int

this[int]

Returns a single object from a collection.

IPivotField this[int index] { get; }

Parameters

index int

The index number for the object.

Property Value

IPivotField

An IPivotField object contained by the collection.

this[string]

Returns a single object from a collection.

IPivotField this[string fieldName] { get; }

Parameters

fieldName string

The name for the object.

Property Value

IPivotField

An IPivotField object contained by the collection.

Methods

Add(string, string)

Creates a new calculated field. Returns a IPivotField object.

IPivotField Add(string Name, string Formula)

Parameters

Name string

The name of the field.

Formula string

The formula for the field.

Returns

IPivotField

An IPivotField that represents the new calculated field.

Remove(string)

Remove the calculated fields by name.

void Remove(string fieldName)

Parameters

fieldName string

Name of calculated field you want to remove