Excel Export for Hierarchial data in the RadGridView

[Raja]

Hi,

          Is there a method or a work around to Export the heirarchial RadGridView data to Excel?

I tried the following methods:

1. Using Telerik.Data.RadGridViewExcelExporter 
2. 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.

[Martin Vasilev]

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.

[Daniel]

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

[Martin Vasilev]

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.

[Jason]

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.

[Martin Vasilev]

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:

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