Hide Expand, Group column in Detailstable

[Pdd]

Hi,

how do I hide the expand column and the group column when exporting detail table  (in hierarchy radgrid) to excel? I can hide the columns in Mastertableview but in detail tables, they are still there.

[Shinu]

Hi Pdd,

Try setting the ExportOnlyData Property to true in the  Export Button click event.

CS:

 protected void Button2_Click(object sender, EventArgs e)
    {
        RadGrid1.ExportSettings.ExportOnlyData = true;
        RadGrid1.ExportSettings.OpenInNewWindow = true;
        RadGrid1.MasterTableView.ExportToExcel();
    }

Thanks
Shinu.