We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Find a cell Name (when a pivot's Heading text is known) for worksheet with many pivots

I want to find the cell names for any heading in a pivot table e.g. F12 etc. Assuming a heading in the pivot is " Sales", I would like to get the cell where it is located e.g. F12.


I have tried using Worksheet.Cells.Find but this work only for the first pivot as there is no way of specifying the second pivot etc.

How can I get the cell name once I know the heading text (for any pivot on the worksheet)




Cheers

I suppose this should be easy. Any help as it is needed urgently!

Hi,


Thank for providing us some details.

Could you provide us your template file with the underlying PivotTable in it, we will check it soon.

Thank you.