GrapeCity.Documents.Excel.IPivotTable.ShowTableStyleColumnStripes

ShowTableStyleColumnStripes Property

ShowTableStyleColumnStripes

Gets or sets whether banded columns are displayed in the PivotTable style.

When this property is true, even columns are formatted differently from odd columns to make the PivotTable easier to read.

Declaration

bool ShowTableStyleColumnStripes { get; set; }

Property ShowTableStyleColumnStripes 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.ShowTableStyleColumnStripes = true;
bool showColumnStripes = pivotTable.ShowTableStyleColumnStripes;