Formatera pivot tabellceller
Contents
[
Hide
]
Ibland vill du formatera pivot-tabellceller. Till exempel kan du vilja tillämpa bakgrundsfärg på pivot-tabellceller. Aspose.Cells för Python via .NET tillhandahåller två metoder PivotTable.format_all(style) och PivotTable.format(row, column, style), som du kan använda för detta ändamål.
PivotTable.format_all(style) tillämpar stilen på hela pivot-tabellen medan PivotTable.format(row, column, style) tillämpar stilen på en enskild cell i pivot-tabellen.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| from aspose.cells import BackgroundType, Workbook | |
| from aspose.pydrawing import Color | |
| # Create workbook object from source file containing pivot table | |
| workbook = Workbook("pivot_format.xlsx") | |
| # Access the worksheet by its name | |
| worksheet = workbook.worksheets.get("Sheet1") | |
| # Access the pivot table | |
| pivotTable = worksheet.pivot_tables[1] | |
| # Create a style object with background color light blue | |
| style = workbook.create_style() | |
| style.pattern = BackgroundType.SOLID | |
| style.background_color = Color.light_blue | |
| # Format entire pivot table with light blue color | |
| pivotTable.format_all(style) | |
| # Create another style object with yellow color | |
| style = workbook.create_style() | |
| style.pattern = BackgroundType.SOLID | |
| style.background_color = Color.yellow | |
| # Access the pivot table | |
| pivotTable2 = worksheet.pivot_tables[0] | |
| # Format the cell of pivot table | |
| pivotTable2.format(16, 5, style) | |
| # Save the workbook object | |
| workbook.save("out.xlsx") |