Get the Cell object by DisplayName of PivotField of PivotTable
Contents
[
Hide
]
Aspose.Cells provides PivotTable.GetCellByDisplayName() method which you can use to access the cell object by display name of pivot field. This method is useful when you want to highlight or format your pivot field header. This article explains how to retrieve the cell object by the display name of data field and then apply formatting to it.
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 |
---|
![]() |
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
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
// The path to the documents directory. | |
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
// Create workbook object from source excel file | |
Workbook workbook = new Workbook(dataDir + "source.xlsx"); | |
// Access first worksheet | |
Worksheet worksheet = workbook.Worksheets[0]; | |
// Access first pivot table inside the worksheet | |
PivotTable pivotTable = worksheet.PivotTables[0]; | |
// Access cell by display name of 2nd data field of the pivot table | |
Cell cell = pivotTable.GetCellByDisplayName(pivotTable.DataFields[0].DisplayName); | |
// Access cell style and set its fill color and font color | |
Style style = cell.GetStyle(); | |
style.ForegroundColor = Color.LightBlue; | |
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 |
---|
![]() |
|