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

export hierarchical grid

26 Answers 521 Views

GridView

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

26 Answers, 1 is accepted

answered on 22 Jul 2010, 02:21 PM

Hi Rieni De Rijke,

You can do this very easily. However, there is one caveat - you need to define a RadGridView in a DataTemplate and put it in your XAML resources, because we'll use this RadGridView to export the children. You just need to handle the ElementExported event:

private void Button1_Click(object sender, RoutedEventArgs e)

{

var saveDialog = new SaveFileDialog();

if (saveDialog.ShowDialog() == true)

{

var stream = saveDialog.OpenFile();

var streamWriter = new System.IO.StreamWriter(stream);

streamWriter.Write(this.clubsGrid.ToCsv());

streamWriter.Close();

MessageBox.Show("Exported.");

}

private void clubsGrid_ElementExported(object sender, GridViewElementExportedEventArgs e)

{

if (e.Element == ExportElement.Row)

{

var template = this.LayoutRoot.Resources["HierarchyChildTemplate"] as DataTemplate;

var grid = template.LoadContent() as RadGridView;

grid.DataContext = e.Context;

var subExport = grid.ToCsv();

e.Writer.Write(subExport);

}

Kind regards,
Yavor Georgiev
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

answered on 26 Jul 2010, 01:00 PM

I used...
                var stream = saveDialog.OpenFile();
                ...
                using (stream)
                {
                    System.Globalization.CultureInfo cultureInfo = new System.Globalization.CultureInfo("nb-NO");
                    myMasterGrid.Export(stream,
                                            new GridViewExportOptions()
                                                {
                                                    Format = ExportFormat.ExcelML,
                                                    ShowColumnHeaders = true,
                                                    ShowColumnFooters = true,
                                                    ShowGroupFooters = true,
                                                    Culture = cultureInfo
                                                });
                }
... and saved it as test.xml.
It still won't open in Excel.
How could we tell the "childgrid" to use the same options?

private void clubsGrid_ElementExported(object sender, GridViewElementExportedEventArgs e)

{

if (e.Element == ExportElement.Row)

{

var template = this.LayoutRoot.Resources["HierarchyChildTemplate"] as DataTemplate;

var grid = template.LoadContent() as RadGridView;

grid.DataContext = e.Context;

var subExport = grid.ToExcelML();

e.Writer.Write(subExport);

}

answered on 26 Jul 2010, 01:50 PM

I'm so sorry... The subExport is empty / null...

private void DgGebyrFakturertElementExported(object sender, GridViewElementExportedEventArgs e)

{

if (e.Element != ExportElement.Row) return;

var template = Resources["HierarchyChildTemplate"] as DataTemplate;

var grid = template.LoadContent() as RadGridView;

Shop shop = (Shop) e.Context;

grid.ItemsSource = shop.Orders;

System.Globalization.CultureInfo cultureInfo = new System.Globalization.CultureInfo("nb-NO");

GridViewExportOptions options = new GridViewExportOptions()

{

Format = ExportFormat.Html,

ShowColumnHeaders = true,

ShowColumnFooters = true,

ShowGroupFooters = true,

Culture = cultureInfo

};

var stream = new MemoryStream();

grid.Export(stream, options);

var subExport = new StreamReader(stream).ReadToEnd();

e.Writer.Write(subExport);

}

The grid has items, the options is ok, the stream is not null, but the subExport is empty / null / nix...

Is it possible to look at an example where a hierarchical grid is exported?

answered on 14 Oct 2010, 02:41 AM

in this method, I need exclude rows that not belong to filtering. Actually, the parent row is ok. but hierarchy row is obtaining all children rows.

private void RadGridView1_ElementExported(object sender, GridViewElementExportedEventArgs e)
{
if (e.Element == ExportElement.Row)
{
string codeHTML;
var template = localContainer.Resources["childrenGridView"] as DataTemplate;
var grid = template.LoadContent() as RadGridView;
grid.ItemsSource = localDataSet.Tables[1].Select("ParentIdentificador=" + ((DataRowView)e.Context).Row["Identificador"]);
grid.ShowGroupPanel = false;
grid.IsFilteringAllowed = true;
var subExport = grid.ToHtml();
codeHTML = "<tr><td> </td><td colspan ='10'>" + subExport + "</td></tr>";
e.Writer.Write(codeHTML);
}
}

the line
grid.ItemsSource = localDataSet.Tables[1].Select("ParentIdentificador=" + ((DataRowView)e.Context).Row["Identificador"]);

I get all children data of row parent. But I need exported only rows that belong to the filter of child row.
help me, please.