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

Excel Export without sub Total

Thread ID:





117484 Oct 29,2014 09:57 AM UTC Nov 3,2014 10:55 AM UTC WinForms 1
Tags: PivotGridControl
Asked On October 29, 2014 09:57 AM UTC

   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.




Neelakandan Kannan [Syncfusion]
Replied On 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.





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

or the page will be automatically redirected to 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