Format Pivot Table Cells

The following sample code loads the sample Excel file that contains two pivot tables, and achieve the operation of formatting the entire pivot table and formatting individual cells in the pivot table.

// Create workbook object from source file containing pivot table
Workbook workbook = new Workbook("pivot_format.xlsx");
// Access the worksheet by its name
Worksheet worksheet = workbook.Worksheets["Sheet1"];
// Access the pivot table
PivotTable pivotTable = worksheet.PivotTables[1];
// Create a style object with background color light blue
Style style = workbook.CreateStyle();
style.Pattern = BackgroundType.Solid;
style.BackgroundColor = Color.LightBlue;
// Format entire pivot table with light blue color
pivotTable.FormatAll(style);
// Create another style object with yellow color
style = workbook.CreateStyle();
style.Pattern = BackgroundType.Solid;
style.BackgroundColor = Color.Yellow;
// Access the pivot table
PivotTable pivotTable2 = worksheet.PivotTables[0];
// Format the cell of pivot table
pivotTable2.Format(16, 5, style);
// Save the workbook object
workbook.Save("out.xlsx");
  • Formatting Pivot Table
  • Working with data display formats of DataField in Pivot Table