[Solved] telerik radgrid export to excel - How to remove default worksheet?

[gafoor]

Hi All,

I have a requirement to export some data (which is completely different from radgrid's columns) into excel sheet when user clicks on radgrid's export to excel command button.   I am able to create new worksheet with required data.  How to remove default worksheet created by radgrid's columns ?

Thanks in advance
Gafoor.
9000999309

[Shinu]

Hi Gafoor,

I guess you want to hide the RadGrid and its Columns on export. Please try the following code snippet:

C#:

protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
  if (e.CommandName == RadGrid.ExportToExcelCommandName)
  {
    RadGrid1.Visible = false;
    foreach (GridColumn col in RadGrid1.Columns)
    {
     RadGrid1.MasterTableView.GetColumn(col.UniqueName).Visible = false;
    }
  }
}

Thanks,
Shinu

[gafoor]

Hi Shinu,

Thank you very much for your response.

I already did the change you suggested to hide grid data in excel worksheet and grid data was not displaying in excel sheet.  But the default worksheet remains exist in excel file.  I want to remove/hide default worksheet as well. Please check attachment which contains excel screenshot. 

Thank you again,
Gafoor.

[Kostadin]

Hello Gafoor,

Could you please let me know which export format you are using? Basically a possible solution is to use the ExportInfrastructure and manually generate the export file. Please check out the following help article which elaborates more on this matter. Additionally you could examine the following code library as well.

Regards,
Kostadin
Telerik

 

 

[gafoor]

Thank you Kostadin,

I referred the links which you provided to export data to excel.

Thanks again,
Gafoor.

[gafoor]

Hello Kostadin & Shinu,

Thanks for your support.

Regards
Gafoor.