How to access the column name inside a pivot table

Aspose.Cells Product Family
,
1

How do you access the column name of a pivot table?
Currently right now I have this pivot table.

image.png (3.2 KB)

How do I access its column names since it uses 2 cells?
Sample result I want would be 2017 Jan, 2017 Feb, and 2018 March.

2

@rmacero,

You may try to use PivotField.Name or PivotField.DisplayName attribute for your needs.
e.g.

pivotTable.ColumnFields[0].Name

If you still could not evaluate, kindly zip and attach your template Excel file containing the pivot table, we will check it soon.