Format Pivot Table Cells

Sometimes, you want to format pivot table cells. For example, you want to apply background color to pivot table cells. Aspose.Cells for Node.js via C++ provides two methods PivotTable.formatAll(style) and PivotTable.format(row, column, style), which you can use for this purpose.

PivotTable.formatAll(style) applies the style to entire pivot table while PivotTable.format(row, column, style) applies the style to a single cell of the pivot table.

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.

const AsposeCells = require("aspose.cells.node");

//Create workbook object from source file containing pivot table
var workbook = new AsposeCells.Workbook("pivot_format.xlsx");
//Access the worksheet by its name
var worksheet = workbook.getWorksheets().get("Sheet1");
//Access the pivot table
var pivotTable = worksheet.getPivotTables().get(1);
//Create a style object with background color light blue
var style = workbook.createStyle();
style.setPattern(AsposeCells.BackgroundType.Solid);
style.setBackgroundColor(AsposeCells.Color.LightBlue);
//Format entire pivot table with light blue color
pivotTable.formatAll(style);
//Create another style object with yellow color
var style = workbook.createStyle();
style.setPattern(AsposeCells.BackgroundType.Solid);
style.setBackgroundColor(AsposeCells.Color.Yellow);

//Access the pivot table
var pivotTable2 = worksheet.getPivotTables().get(0);
//Format the cell of pivot table
pivotTable2.format(16, 5, style);
//Save the workbook object
workbook.save("out.xlsx");

Related Articles

• Formatting Pivot Table
• Working with data display formats of DataField in Pivot Table