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: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to Use IPivotTable's PivotEngineValues Property.

Thread ID:





131573 Jul 17,2017 11:44 AM UTC Jul 18,2017 12:58 PM UTC WinForms 1
Tags: XlsIO
Asked On July 17, 2017 01:06 PM UTC

I am using XlsxIO to build my WinFormApp, and some problems confuse me. I know that the PivotTable has a property called PivotEngineValues, and I create a pivot table in a worksheet. When I check the PivotEngineValues property, It is NULL. Sorry to say that I don't Know how to use it, seems that PivotEngineValues property has many useful properties and methods to help to customize the pivot table, but it is NULL during the runtime. How to instantiate it, or get an instance of it.Do you guys have some sample code? Thank you very much.

Sridhar Sukumar [Syncfusion]
Replied On July 18, 2017 12:58 PM UTC

Hi Kevin, 
Thank you for contacting Syncfusion support. 
You can get the PivotEngineValues property by setting layout to pivot table. Please refer the following code example to set layout for pivot table. 
Code snippet: 
Please let us know if you have any concern. 


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