Get the Cell object by DisplayName of PivotField of PivotTable

How to Get the Cell object by DisplayName of PivotField of PivotTable

The following code accesses the first pivot table of the worksheet and then get cell by display name of second data field of the pivot table. It then changes the fill color and font color of the cell to light blue and black respectively. Below screenshots show how the pivot table looks before and after the execution of the code.

Pivot Table - Before
todo:image_alt_text
from aspose.cells import Workbook
from aspose.pydrawing import Color
# For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
# The path to the documents directory.
dataDir = RunExamples.GetDataDir(".")
# Create workbook object from source excel file
workbook = Workbook(dataDir + "source.xlsx")
# Access first worksheet
worksheet = workbook.worksheets[0]
# Access first pivot table inside the worksheet
pivotTable = worksheet.pivot_tables[0]
# Access cell by display name of 2nd data field of the pivot table
cell = pivotTable.get_cell_by_display_name(pivotTable.data_fields[0].display_name)
# Access cell style and set its fill color and font color
style = cell.get_style()
style.foreground_color = Color.light_blue
style.font.color = Color.black
# Set the style of the cell
pivotTable.format(cell.row, cell.column, style)
# Save workbook
workbook.save(dataDir + "output_out.xlsx")
Pivot Table - After
todo:image_alt_text