GrapeCity.Documents.Excel.IPivotFormulas

IPivotFormulas Interface

Represents the collection of custom formulas in a PivotTable.

An IPivotFormulas object is returned by PivotFormulas and provides access to the formulas defined for a PivotTable, such as formulas created by calculated items.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public interface IPivotFormulas : IEnumerable<IPivotFormula>, IEnumerable

Public Interface IPivotFormulas
    Inherits IEnumerable(Of IPivotFormula), IEnumerable

Examples

worksheet.Range["A1:C4"].Value = new object[,] {
    {"Product", "Category", "Amount"},
    {"Apple", "Fruit", 120},
    {"Banana", "Fruit", 80},
    {"Bran", "Snack", 60}
};
IPivotCache pivotCache = workbook.PivotCaches.Create(worksheet.Range["A1:C4"]);
IPivotTable pivotTable = worksheet.PivotTables.Add(pivotCache, worksheet.Range["E1"], "SalesPivot");
pivotTable.PivotFields["Product"].Orientation = PivotFieldOrientation.RowField;
pivotTable.PivotFields["Amount"].Orientation = PivotFieldOrientation.DataField;
pivotTable.PivotFields["Category"].Orientation = PivotFieldOrientation.ColumnField;
pivotTable.PivotFields["Product"].CalculatedItems().Add("TotalFruit", "=Product[Apple] + Product[Banana]");
IPivotFormulas formulas = pivotTable.PivotFormulas;

Properties

Name	Description
Count	Gets the number of pivot formulas in this collection. This collection is returned by PivotFormulas and contains the formulas defined for a PivotTable, such as formulas created by calculated items.
this[int]	Gets the IPivotFormula at the specified index. Use this property to retrieve a formula from the PivotFormulas collection, such as a formula created by a calculated item in a PivotTable.

Name

Description

Count

Gets the number of pivot formulas in this collection.

This collection is returned by PivotFormulas and contains the formulas defined for a PivotTable, such as formulas created by calculated items.

this[int]

Gets the IPivotFormula at the specified index.

Use this property to retrieve a formula from the PivotFormulas collection, such as a formula created by a calculated item in a PivotTable.