GrapeCity.Documents.Excel.IPivotTable.Name

Name Property

Name

Gets or sets the name of the PivotTable.

The name identifies the PivotTable on the worksheet and can be used to reference the PivotTable programmatically.

Declaration

string Name { get; set; }

Property Name As String

Examples

worksheet.Range["A1:C4"].Value = new object[,] {
    {"Region", "Product", "Amount"},
    {"East", "Apple", 120},
    {"West", "Apple", 80},
    {"East", "Orange", 90}
};
IPivotCache pivotCache = workbook.PivotCaches.Create(worksheet.Range["A1:C4"]);
IPivotTable pivotTable = worksheet.PivotTables.Add(pivotCache, worksheet.Range["E1"], "SalesPivot");
string name = pivotTable.Name;