hierarchial grid to excel

[Erin]

Hi
 i want to export a hierarchial grid to excel. But the child rows are not visible. I have tried expanding the child grid on export, but its not working. Any idea?

[Princy]

Hi Erin,

Please try the following code snippet, if this doesn't help please provide your full code snippet:

C#:

protected void myRadGrid_ItemCommand(object sender, GridCommandEventArgs e)
{
  if(e.CommandName == RadGrid.ExportToExcelCommandName)
   RadGrid1.MasterTableView.HierarchyDefaultExpanded = true;
}

Thanks,
Princy