Format Pivot Table Cells
Contents
[
Hide
]
Sometimes, you want to format pivot table cells. For example, you want to apply background color to pivot table cells. Aspose.Cells provides two methods PivotTable.FormatAll() and PivotTable.Format(), which you can use for this purpose.
PivotTable.FormatAll() applies the style to entire pivot table while PivotTable.Format() applies the style to a single cell of the pivot table.
The following sample code formats the entire pivot table with a light blue color and then formats the table’s second row yellow.