Grouping Grid To Excel

[Abhishek Shivalingaiah]

VS 2005
Syncfusion 5.1

When exporting GGC to excel the GroupCaptionSummaryCell cell values are not exported. How do I get those values to be exported to excel?

Thanks

[Jeba S]

Hi Shek,

Thank you for posting query to us.

Currently this feature[Support for exporting GridGroupingControl with summary in group caption to excel sheet] is not implemented in our GridGroupingExcelConverter.

We have already logged it as a feature request and notified our development team. We will implement this feature in our forthcoming new version releases or service pack releases. We usually have a timeframe of at least three months between releases. The feature implementation would also greatly depend on the factors like product design, code compatibility and complexity. We will get back to you once the feature is implemented.

Thank you for using Syncfusion Products.

Best Regards,
Jeba.

[Abhishek Shivalingaiah]

Thanks, Jeba. Do we have an apprx ETA on when this feature will be availalbe?


>Hi Shek,

Thank you for posting query to us.

Currently this feature[Support for exporting GridGroupingControl with summary in group caption to excel sheet] is not implemented in our GridGroupingExcelConverter.

We have already logged it as a feature request and notified our development team. We will implement this feature in our forthcoming new version releases or service pack releases. We usually have a timeframe of at least three months between releases. The feature implementation would also greatly depend on the factors like product design, code compatibility and complexity. We will get back to you once the feature is implemented.

Thank you for using Syncfusion Products.

Best Regards,
Jeba.

[Jeba S]

Hi Shek,

On further analysis we found that this can be achieved by customizing the GroupingExcelConvertorControl for exporting GridGroupingControl with summary in group caption to excel sheet. The covered range can be obtained from the QueryCoveredRange event handler for the caption elements (non - display elements).

Please refer the sample which implements the idea:
http://websamples.syncfusion.com/samples/Grid.Windows/F68234/main.htm

Kindly let us know if you need any further assistance.

Best Regards,
Jeba.