GrapeCity.Documents.Excel.IPivotTable.DisplayFieldCaptions

DisplayFieldCaptions Property

DisplayFieldCaptions

Gets or sets a value indicating whether filter buttons and pivot field captions for rows and columns are displayed in the grid. Default value is true.

Declaration

bool DisplayFieldCaptions { get; set; }

Property DisplayFieldCaptions As Boolean

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Name", "Amount"},
    {"A", 100},
    {"B", 200},
    {"A", 150}
};
IPivotCache pivotCache = workbook.PivotCaches.Create(worksheet.Range["A1:B4"]);
IPivotTable pivotTable = worksheet.PivotTables.Add(pivotCache, worksheet.Range["D1"], "SalesPivot");
pivotTable.DisplayFieldCaptions = false;
bool displayFieldCaptions = pivotTable.DisplayFieldCaptions;