ExportingToExcel raw data with no grouping

2 posts, 0 answers
  1. NVB
    NVB avatar
    39 posts
    Member since:
    Apr 2009

    Posted 07 Jun 2012 Link to this post

    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
  2. Shinu
    Shinu avatar
    17764 posts
    Member since:
    Mar 2007

    Posted 07 Jun 2012 Link to this post

    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.
Back to Top