This is a migrated thread and some comments may be shown as answers.

Excel Export for Hierarchial data in the RadGridView

5 Answers 242 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Raja
Top achievements
Rank 1
Raja asked on 07 Aug 2008, 03:01 PM
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.

5 Answers, 1 is accepted

Sort by
0
Martin Vasilev
Telerik team
answered on 08 Aug 2008, 12:25 PM
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.
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


0
Martin Vasilev
Telerik team
answered on 10 Apr 2009, 07:25 AM
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.
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.
0
Martin Vasilev
Telerik team
answered on 19 Apr 2011, 02:19 PM
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
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
Tags
GridView
Asked by
Raja
Top achievements
Rank 1
Answers by
Martin Vasilev
Telerik team
Daniel
Top achievements
Rank 1
Jason
Top achievements
Rank 2
Share this question
or