Format Pivot Table Cells with Golang via C++
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 the entire pivot table, while PivotTable::Format() applies the style to a single cell of the pivot table.
The following sample code loads the sample Excel file (pivot_format.xlsx) that contains two pivot tables and demonstrates how to format the entire pivot table as well as individual cells in the pivot table.