Not able to style my pivot table with background colors and fonts in Aspose.Cells Python

Screenshot.png (54.2 KB)


You cannot apply formatting directly to the cells of the pivot table report. You may use PivotTable.format/formatAll for the purpose. See the document with example code on how to format pivot table cells for your reference.

The sample code here is in java.
i require it in python.
@Amjad_Sahi can you help me a script in python?


Both Aspose.Cells for Java and Aspose.Cells for Python via Java share almost the same APIs. So, you may refer to the mentioned Java code (I am afraid, we have not written similar topic in Aspose.Cells for Python via Java Docs yet) and write your code accordingly in Python. See the API Reference page where these methods are mentioned.

1 Like