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

[Solved] Remove group header while exporting to excel

1 Answer 211 Views

Grid

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

1 Answer, 1 is accepted

answered on 20 Nov 2009, 07:01 AM

Hi Suhua,

Try the following code snippet in order to hide the groupheader when exporting.

CS:

    
                protected void Button1_Click(object sender, EventArgs e) 
        
                { 
        
                    RadGrid1.ExportSettings.ExportOnlyData = true; 
        
                    RadGrid1.ExportSettings.OpenInNewWindow = true; 
        
                    foreach (GridGroupHeaderItem groupItem in this.RadGrid1.MasterTableView.GetItems(GridItemType.GroupHeader)) 
        
                    { 
        
                        groupItem.Visible = false; 
        
                    } 
        
                    RadGrid1.MasterTableView.ExportToExcel();  
        
                }

Thanks,
Shinu.