This project has moved. For the latest updates, please go here.

facing issues while trying to add a row field from a page field - Pivot table

Jul 6, 2011 at 10:57 AM

i have few page fields in my pivot table and i am adding this page field as a row field. i am getting an error while trying to do this. Sample code below



pivotTable.DataOnRows = true;



when ever we add a row field which is available in page fields, this same field will be removed from page field and it adds up in the row field and the pivot table gets refreshes. Let me know how to handle this scenario in EPPlus. In excel dll it can be handled and as epplus is binary data i am not able to find the code for this scenario. Also there is no option for refreshing the data in pivot table with EPPlus dll.

Your help will be appreciated.

Thanks in advance.