Format Pivot Table Cells

Contents
[ ]

The following sample code formats the entire pivot table with a light blue color and then formats the second table row yellow.

The input pivot table, before executing the code

todo:image_alt_text

The ouput pivot table, after the executing the code

todo:image_alt_text

import jpype
import asposecells
jpype.startJVM()
from asposecells.api import Workbook, SaveFormat
# Create workbook object from source file containing pivot table
workbook = Workbook("pivotTable_test.xlsx")
# Access the worksheet by its name
worksheet = workbook.getWorksheets().get("PivotTable")
# Access the pivot table
pivotTable = worksheet.getPivotTables().get(0)
# Create a style object with background color light blue
style = workbook.createStyle()
style.setPattern(BackgroundType.SOLID)
style.setBackgroundColor(Color.getLightBlue())
# Format entire pivot table with light blue color
pivotTable.formatAll(style)
# Create another style object with yellow color
style = workbook.createStyle()
style.setPattern(BackgroundType.SOLID)
style.setBackgroundColor(Color.getYellow())
# Format the cells of the first row of the pivot table with yellow color
columns = [0, 1, 2, 3, 4]
for x in columns:
pivotTable.format(1, x, style)
# Save the workbook object
workbook.save("out.xlsx")
jpype.shutdownJVM()