GrapeCity.Documents.Excel.IPivotTable.ShowTableStyleRowHeaders

ShowTableStyleRowHeaders Property

ShowTableStyleRowHeaders

Gets or sets whether row headers are displayed in the PivotTable style.

Use this property to determine whether the current PivotTable style shows row header formatting.

Declaration

bool ShowTableStyleRowHeaders { get; set; }

Property ShowTableStyleRowHeaders As Boolean

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Category", "Amount"},
    {"Fruit", 100},
    {"Drink", 200},
    {"Fruit", 150}
};
IPivotCache pivotCache = workbook.PivotCaches.Create(worksheet.Range["A1:B4"]);
IPivotTable pivotTable = worksheet.PivotTables.Add(pivotCache, worksheet.Range["D1"], "SalesPivot");
pivotTable.ShowTableStyleRowHeaders = true;
bool showRowHeaders = pivotTable.ShowTableStyleRowHeaders;