[Solved] Export Hierarchal RadGrdi

[Saqib]

Hi,
    I am trying to find a sample code which deals with exporting Hierarchal RadGrid. Can anybody point me in right direction how to achieve this goal?

Thanks
Saqib

[Shinu]

Hi ,

Try the following code snippet and see whether it helps.

CS:

protected void Button1_Click(object sender, EventArgs e)
    {
        RadGrid1.MasterTableView.HierarchyDefaultExpanded = true;
        RadGrid1.MasterTableView.Rebind();
        RadGrid1.ExportSettings.ExportOnlyData = true;
        RadGrid1.ExportSettings.OpenInNewWindow = true;
        RadGrid1.MasterTableView.ExportToExcel();



    }

Shinu

[Saqib]

Thanks Shinu that worked, but it's not working when i changed export format from Excel to ExcelML. On button click it shows the dialog box to open or save an excel file but that excel file doesn't contain any data. Does Hierarchal RadGrid Export works with ExcelML format?

Thanks
Saqib

[Pavlina]

Hello Saqib,

For your convenience I am sending you a sample application. Please find it attached to this post.
Give it a try and see if it works for you.

Best regards,
Pavlina
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.