We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to iterate through Pivot Field Items

Thread ID:

Created:

Updated:

Platform:

Replies:

144287 Apr 29,2019 08:58 AM UTC May 2,2019 08:33 AM UTC ASP.NET Web Forms 4
loading
Tags: XlsIO
Mani Barathi Saravanan
Asked On April 29, 2019 08:58 AM UTC

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 [Syncfusion]
Replied On April 30, 2019 12:06 PM UTC

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. 


Please check and let us know if this is helpful. 

Regards, 
Abirami 


Mani Barathi Saravanan
Replied On April 30, 2019 12:35 PM UTC

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
Replied On April 30, 2019 12:38 PM UTC

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

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


Abirami Varadharajan [Syncfusion]
Replied On May 2, 2019 08:33 AM UTC

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. 
 
 
 
Can the below incident be looked into and actioned at the earliest? 
 
We have posted the solution for your query in mentioned incident. Please log on to our support website to check for further updates.      
       
      
 

Regards, 
Abirami 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon