格式化数据透视表单元格

Contents
[ ]

以下示例代码将整个数据透视表格式化为浅蓝色,然后将第二行表格式化为黄色。

执行代码前的输入数据透视表

todo:image_alt_text

执行代码后的输出数据透视表

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()