ExportingToExcel raw data with no grouping

[NVB]

I have Radgrid with 2 levels of grouping

The basic export is exporting the data in the format that it is displayed. i.e with  groups level

Is there anyway I can export the raw data of the grid i.e with no grouping. Also I would like to omit certain columns from exporting (i.e for  example I have dept_code and dept_name . Dept_code is the code value for Dept name, so in this i want to export only Dept name )

Thanks for your help

[Shinu]

Hello,

Try the following code to achieve your scenario.
C#:

void Button1_Click(object sender, EventArgs e)
{
    RadGrid1.GroupingEnabled = false;
    RadGrid1.Rebind();
    RadGrid1.MasterTableView.GetColumn("UniqueName").Visible = false;
    RadGrid1.MasterTableView.ExportToExcel();
}

Thanks,
Shinu.