How to iterate through Pivot Field Items

[Mani Barathi Saravanan]

I need to loop through pivot field Items,

when I used for loop,

pivotField.Items[i].Text returns null .

But I found that there is a non -public member Name from Items[]

A solution on how to access it will be helpful.

Your quick response is appreciated.

Thank you in Advance!

[Abirami Varadharajan]

Hi Mani, 

We have prepared sample to access the internal property ‘Name’ using reflection which returns the name of the pivot field item. The sample can be downloaded from following link. 

Sample Link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/XlsIO_Sample-717335869.zip  

Please check and let us know if this is helpful. 

Regards, 

Abirami 

[Mani Barathi Saravanan]

Hello Abirami,

Thank you for the solution. This is what I was expecting.

But if the pivot Item label is (blank) in Excel, it shows null.

Is this the behavior of syncfusion or is there a way to get that as well?

[Mani Barathi Saravanan]

Can the below incident be looked into and actioned at the earliest?

https://www.syncfusion.com/support/directtrac/incidents/234789

[Abirami Varadharajan]

Hi Mark, 

Please find the details below. 

Queries	Details
But if the pivot Item label is (blank) in Excel, it shows null.  Is this the behavior of syncfusion or is there a way to get that as well?	When the pivot item label is blank, we will return ‘Name’ property as Null. This is the behaviour of XlsIO. However, we have modified the sample to return the blank label as Null and the sample can be downloaded from the following link.    Sample Link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/XlsIO_Sample1772062161.zip
Can the below incident be looked into and actioned at the earliest?    https://www.syncfusion.com/support/directtrac/incidents/234789	We have posted the solution for your query in mentioned incident. Please log on to our support website to check for further updates.               https://www.syncfusion.com/account/login

Regards, 

Abirami