Hi,
Is there a method or a work around to Export the heirarchial RadGridView data to Excel?
I tried the following methods:
Is there a method or a work around to Export the heirarchial RadGridView data to Excel?
I tried the following methods:
- Using Telerik.Data.RadGridViewExcelExporter
- Using RadGridReportingLite. sample code using RadLite.
(RadGridReport rep = new RadGridReport(strFileName);
rep.ReportFormShow(
this, this.radGridView1);
both of them are exporting only MasterTable Data. child Table data is not exported.
Please suggest any solution.
Thank you,
Raja.
5 Answers, 1 is accepted
0
Hi Raja,
Thank you for writing.
Currently, RadControls suite does not include support of exporting child views of RadGridView to Excel. The main reason is because Excel has not build-in support for hierarchical data. Nevertheless, I will highly appreciate if you share with me how do you want to present hierarchy RadGridView in Excel spreadsheet. We always take into consideration on any good customer's idea and we could implement it in the feature versions.
I am looking forward to your reply.
Best wishes,
Martin Vasilev
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Thank you for writing.
Currently, RadControls suite does not include support of exporting child views of RadGridView to Excel. The main reason is because Excel has not build-in support for hierarchical data. Nevertheless, I will highly appreciate if you share with me how do you want to present hierarchy RadGridView in Excel spreadsheet. We always take into consideration on any good customer's idea and we could implement it in the feature versions.
I am looking forward to your reply.
Best wishes,
Martin Vasilev
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0

Daniel
Top achievements
Rank 1
answered on 08 Apr 2009, 06:37 PM
I have the same need to export hierarchical data from a RadGridView to Excel. It would be perfectly acceptable if the "child" rows where just indented one column so you could easily tell where in the heirarchy the rows are. An example is below.
Thanks,
- Daniel
master column, column, column, column, column, column
master column, column, column, column, column, column
master column, column, column, column, column, column
child column, column, column, column, column, column
child column, column, column, column, column, column
child column, column, column, column, column, column
master column, column, column, column, column, column
master column, column, column, column, column, column
master column, column, column, column, column, column
child column, column, column, column, column, column
child column, column, column, column, column, column
child column, column, column, column, column, column
child column, column, column, column, column, column
master column, column, column, column, column, column
Thanks,
- Daniel
master column, column, column, column, column, column
master column, column, column, column, column, column
master column, column, column, column, column, column
child column, column, column, column, column, column
child column, column, column, column, column, column
child column, column, column, column, column, column
master column, column, column, column, column, column
master column, column, column, column, column, column
master column, column, column, column, column, column
child column, column, column, column, column, column
child column, column, column, column, column, column
child column, column, column, column, column, column
child column, column, column, column, column, column
master column, column, column, column, column, column
0
Hello Daniel,
Thank you very much for sharing your opinion with us.
We did not implement such an exporting format because this will not be a real hierarchical data. With the suggested format you cannot make any excel data formatting operation such as sorting, filtering, column editing etc. Nevertheless we will consider this as a possible option that we could include in the future versions and especially if we receive more demand for the same format.
I have updated your Telerik points for the suggestion. Do not hesitate to contact me again if you have other questions.
All the best,
Martin Vasilev
the Telerik team
Check out Telerik Trainer , the state of the art learning tool for Telerik products.
Thank you very much for sharing your opinion with us.
We did not implement such an exporting format because this will not be a real hierarchical data. With the suggested format you cannot make any excel data formatting operation such as sorting, filtering, column editing etc. Nevertheless we will consider this as a possible option that we could include in the future versions and especially if we receive more demand for the same format.
I have updated your Telerik points for the suggestion. Do not hesitate to contact me again if you have other questions.
All the best,
Martin Vasilev
the Telerik team
Check out Telerik Trainer , the state of the art learning tool for Telerik products.
0

Jason
Top achievements
Rank 2
answered on 14 Apr 2011, 01:27 PM
Guys,
I rad with interest the thread on hierarchical data from RadGridView to Excel and wondered if any of this functionality had thus far been implemented in the latest WinForm tools? I tried attach a couple of excel sheets that show a couple of way I would like to see the data exported but the format is not permitted; is there a way to get .xls files to you? I also attach a screen grab of the app so you can visualise how the data is being used.
Thanks,
Jason.
I rad with interest the thread on hierarchical data from RadGridView to Excel and wondered if any of this functionality had thus far been implemented in the latest WinForm tools? I tried attach a couple of excel sheets that show a couple of way I would like to see the data exported but the format is not permitted; is there a way to get .xls files to you? I also attach a screen grab of the app so you can visualise how the data is being used.
Thanks,
Jason.
0
Hi Jason,
Thank you for writing.
Actually, I have some good news here. We have implemented exporting hierarchical data in our latest release Q1 2011 (2011.1.11.315). You just have to set the ExportHierarchy property to true:
Let me know if you have any additional questions.
All the best,
Martin Vasilev
the Telerik team
Thank you for writing.
Actually, I have some good news here. We have implemented exporting hierarchical data in our latest release Q1 2011 (2011.1.11.315). You just have to set the ExportHierarchy property to true:
ExportToExcelML excelExporter =
new
ExportToExcelML(radGridView);
excelExporter.ExportHierarchy =
true
;
excelExporter.ExportVisualSettings =
true
;
excelExporter.RunExport(filePath);
Let me know if you have any additional questions.
All the best,
Martin Vasilev
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items