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. Image for the cookie policy date

Excel Export without sub Total

   I am currently working with pivotgridcontrol, I given option for user's to Hide/Unhide the sub total in the data they analysing.
   For that i used this coding
   (GrdPivotGrd.ShowSubTotals = False/True).
 Now User want to export data in excel without Sub total but while exporting, PivotGrid sending the data to excel with subtotal.
 I want to Export the data to excel like how user arranged in grid as it is.




1 Reply

NK Neelakandan Kannan Syncfusion Team November 3, 2014 10:55 AM UTC

Hi Ashokraj,


Thank you for your interest in syncfusion products.


We regret to let you know that currently we don’t have separate support for exporting the pivot grid to excel without Showsubtotal row. Currently we have support for only exporting the whole PivotGridControl to excel with cell by cell basis and Pivot table basis. We have logged feature report. For this, Please create a DT incident for your query for your better follow up.


You can create the DT incident from the following link.



Please let me know if you have further concerns.




Live Chat Icon For mobile
Up arrow icon