Do not export ColumnGroups to Excel

[Fabio]

Hello,

I would like not to export a ColumnGroups to Excel, if I simply make the columns that are part of the column group invisible it presents an error.

I really wish I didn't have ColumnGroups, as it doesn't make sense in my spreadsheet.

Thank you very much in advance

[Zach]

https://docs.telerik.com/devtools/aspnet-ajax/api/server/telerik.web.ui/gridboundcolumn#exportable

 

Try setting the Exportable value of the column to false. Exportable is a property of GridBoundColumn and will be available on all telerik grid columns.

[Attila Antal]

Hello Fabio,

If you wish to exclude a column from the exported file, you can set the Exportable property to false as suggested by Zach.

To exclude the ColumnGroups, you can attach the ItemCommand event to the Grid and capture the Export Command. When this command is triggered, try clearing the ColumnGroups and rebinding the Grid.

Example

protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
    RadGrid grid = (RadGrid)sender;

    if(e.CommandName == RadGrid.ExportToExcelCommandName)
    {
        grid.MasterTableView.ColumnGroups.Clear();
        grid.MasterTableView.Rebind();
    }
}

 

Regards,
Attila Antal
Progress Telerik