export to Excel of a three-tiered GridView

[lina fetisova]

Good day!
we have a project with Silverlight3 and bot the latest version of Telerik
we export our grids to excel this way:

public static void ExportToXls(RadGridView grid)
        {
            SaveFileDialog textDialog = new SaveFileDialog();
            textDialog.Filter = "XLS Files | *.csv";
            textDialog.DefaultExt = "csv";
            bool? result = textDialog.ShowDialog();
            if (result == true)
            {
                  System.Text.Encoding ascii = System.Text.Encoding.UTF8;
                  Encoding enc=Encoding.GetEncoding("cp1251");
                  string data = ExportExtensions.ToCsv(grid, true);
              //  data+=@"<script type=""text/javascript"">print();</script>";
                  data = data.Replace(",", ";");
                  System.IO.Stream fileStream = textDialog.OpenFile();
                  byte[] contents = enc.GetBytes(data);
                  fileStream.Write(contents, 0, contents.Length);
                  fileStream.Flush();
                  fileStream.Close();
            }
        }

but we have no idea how to make export to excel of three-tiered GridView (somthing like this:

<telerikGridView:RadGridView>
    <telerikGridView:RadGridView.ChildTableDefinitions>               
                <telerikGridView:GridViewTableDefinition>
                    <telerikGridView:GridViewTableDefinition.Relation>
                        <telerikData:PropertyRelation ParentPropertyName="WorkPlaces" />
                    </telerikGridView:GridViewTableDefinition.Relation>
                </telerikGridView:GridViewTableDefinition>                    
            </telerikGridView:RadGridView.ChildTableDefinitions>
            
            <telerikGridView:RadGridView.HierarchyChildTemplate>
                <DataTemplate>
                    <telerikGridView:RadGridView ItemsSource="{Binding WorkPlaces}" >
                        <telerikGridView:RadGridView.ChildTableDefinitions>
                            <telerikGridView:GridViewTableDefinition>
                                <telerikGridView:GridViewTableDefinition.Relation>
                                    <telerikData:PropertyRelation ParentPropertyName="Licenses" />
                                </telerikGridView:GridViewTableDefinition.Relation>
                            </telerikGridView:GridViewTableDefinition>
                        </telerikGridView:RadGridView.ChildTableDefinitions>

                        <telerikGridView:RadGridView.HierarchyChildTemplate>
                            <DataTemplate>
                                <telerikGridView:RadGridView
                                    ItemsSource="{Binding Licenses}" >
                                </telerikGridView:RadGridView>
                    </telerikGridView:RadGridView>
</telerikGridView:RadGridView>

I want to see information of all the Girds in Excel.
How can I make it?

[Vlad]

Hello ,

 Exporting hierarchal grids currently is not supported. You can use printing instead if this makes sense in your scenario. 

Greetings,
Vlad
the Telerik team

[Keerti]

Hi,

Is this functionality available now ? . If its not available can you let us know in which release this will be available.

Thanks & Regards,
Keerti Somasundaram

[Dimitrina]

Hi Keerti,

 Yes, with the latest release of the RadControls the functionality of exporting Grids in hierarchy is available. You may find it helpful to review this exporting row details online demo, where it is shown how the row details/hierarchy table could be exported.

I am attaching an example project showing how the export is working using HierarchyChildTemplate for two hierarchal child grids.
You have to use the Export method of the RadGridView. In order to implement the hierarchy exporting you need to subscribe to the ElementExported event of the parent grid and inside it add a logic for exporting the related Hierarchal grid.

In the sample project that I am referencing, there are used two DataTemplates for the child grids. The content of the child grid is exported to html and then added to the excel file that is currently being exporting:

private void clubsGrid_ElementExported(...)
      {
          if (e.Element == ExportElement.Row)
          {
              var template = this.LayoutRoot.Resources["Hierarchy1"] as DataTemplate;
              var grid = template.LoadContent() as RadGridView;
              grid.DataContext = e.Context;
              var subExport = grid.ToHtml();
              var columns = this.clubsGrid.Columns.OfType<GridViewBoundColumnBase>().Count();
              var row = string.Format("<tr><td colspan=\"{0}\">{1}</td></tr>", columns, subExport);
              e.Writer.Write(row);
          }
      }

The first Hierarchy child grid should subscribe to its ElementExported event as well, so that its child grid to be exported.

Regards,
Didie
the Telerik team