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

ExportingToExcel raw data with no grouping

1 Answer 16 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
NVB
Top achievements
Rank 1
NVB asked on 08 Jun 2012, 02:34 AM
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

1 Answer, 1 is accepted

Sort by
0
Shinu
Top achievements
Rank 2
answered on 08 Jun 2012, 04:48 AM
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.
Tags
General Discussions
Asked by
NVB
Top achievements
Rank 1
Answers by
Shinu
Top achievements
Rank 2
Share this question
or