Döşeme Özeti Hücreleri Biçimlendir
Contents
[
Hide
]
Bazı durumlarda, dinamik tablo hücrelerini biçimlendirmek isteyebilirsiniz. Örneğin, dinamik tablo hücrelerine arka plan rengi uygulamak isteyebilirsiniz. Aspose.Cells for Python via .NET, bu amaçla kullanabileceğiniz iki yöntem PivotTable.format_all(style) ve PivotTable.format(row, column, style) sağlar.
PivotTable.format_all(style), stilin tam döşeme tablosuna PivotTable.format(row, column, style), stilin döşeme tablosunun tek bir hücresine uygulanmasını sağlar.
This file contains hidden or 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") |