How to hide the edit column before exporting to excel

[Paul Stack]

hi

i have used a rad grid with the edit column user control. i have also got a ExportToExcel functionality on the page. when the users fires the edit command a graph shows up on the page but then this graph does not go away for the export to excel functionality. i have tried a few ways of hiding the form but to no avail

protected void btnExportToExcel_Click(object sender, EventArgs e)
{
    rgMetrics.MasterTableView.EditFormSettings.EditColumn.Visible = false;
    rgMetrics.MasterTableView.ExportToExcel();
}

this does not work - is there anything you can advise me on?

thnaks

paul

[Paul Stack]

i have solved this problem -

thanks

paul

[jfkrueger]

how did you solve your problem?

[Shinu]

Hi Joe,


You can access a Grid column using its columnUniqueName and hide it using its Visible property in the click event of the Export button

ASPX:

                    <telerik:GridEditCommandColumn UniqueName="EditColumn">
                    </telerik:GridEditCommandColumn>

CS:

 private void Button1_Click(object sender, System.EventArgs e)
{

  // access the EditColumn using its columnUniqueName
  RadGrid1.MasterTableView.Columns.FindByUniqueName( "EditColumn").Visible = false;

  RadGrid1.ExportSettings.OpenInNewWindow = true;
  RadGrid1.MasterTableView.ExportToExcel();
}

Exporting tips and tricks



Thanks
Shinu