GrapeCity.Documents.Excel.IPivotFormula.Name

Name Property

Name

Gets the name of the current PivotTable formula.

Use this property to retrieve the formula name from an IPivotFormula in the PivotFormulas collection.

Declaration

string Name { get; }

ReadOnly Property Name As String

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", "=Apple + Banana");
string formulaName = pivotTable.PivotFormulas[0].Name;