Hierarchical Grid, Collapse the Expand/Collapse column prior to export.

[gc_0620]

Folks,

Using ASP.Net Ajax V2010 Release 2 with VStudio 2008 SP1.

We would like to collapse the expand/collapse column (if it is expanded) prior to export. Below is my command; basically prior to export, I would like to see if expand/collapse column is already expanded by user. If so collapse it 1st and then do export.
 
Thanks

protected void Export_Excel_Click(object sender, System.EventArgs e)
    {
        RadGrid1.MasterTableView.HierarchyDefaultExpanded = true;
        RadGrid1.ExportSettings.IgnorePaging = CheckBox2.Checked;
        RadGrid1.ExportSettings.OpenInNewWindow = true;
        RadGrid1.ExportSettings.Excel.Format =  Telerik.Web.UI.GridExcelExportFormat.ExcelML;

        RadGrid1.ExportSettings.ExportOnlyData = true;
        RadGrid1.MasterTableView.ExportToExcel();
    }

 

[Princy]

Hello,

The following code snippet will help you to achieve this. You can loop through each item and check whether it is expanded or not .If it is expanded, collapse it first and then export the grid.

C#:

protected void RadGrid1_ItemCommand(object source, GridCommandEventArgs e)
   {
      if (e.CommandName == RadGrid.ExportToExcelCommandName )
       {
          foreach (GridDataItem item in RadGrid1.MasterTableView.Items)
           {
               if (item.Expanded)// checking whether the item is expanded or not
                   item.Expanded = false;
           }
           RadGrid1.ExportSettings.OpenInNewWindow = true;
           RadGrid1.MasterTableView.ExportToExcel();
       }
   }

Thanks,
Princy.