GrapeCity.Documents.Excel.ICalculatedItems

Interface ICalculatedItems

Namespace

GrapeCity.Documents.Excel

Assembly

GcDocs.Excel.dll

A collection of PivotItem objects that represent all the calculated items in the specified PivotTable report.

public interface ICalculatedItems : IEnumerable<IPivotItem>, IEnumerable

Inherited Members

IEnumerable<IPivotItem>.GetEnumerator()

Properties

Count

Returns the number of IPivotItem in the collection.

int Count { get; }

Property Value

int

this[int]

Get IPivotItem item by index.

IPivotItem this[int index] { get; }

Parameters

index int

index of calculated item

Property Value

IPivotItem

IPivotItem.

this[string]

Get IPivotItem item by name.

IPivotItem this[string itemName] { get; }

Parameters

itemName string

name of calcluated item.

Property Value

IPivotItem

Methods

Add(string, string)

Creates a new calculated item. Returns a PivotItem object.

IPivotItem Add(string name, string formula)

Parameters

name string

The name of the calculated item.

formula string

The formula for the calculated item.

Returns

IPivotItem

IPivotItem.

Remove(string)

Remove calculated item.

void Remove(string itemName)

Parameters

itemName string

name of calculated item.