How to Customize The Columns Exported in a RadGrid?

[Pooya]

I have a radgrid control which is bound to some data.
One of the columns is an image that I'd like to be excluded from my export button.
How can this be done?

Thanks

[Princy]

Hello Pooya,


It is achievable by hiding the code before exporting the grid.

Code:

protected void RadGrid1_ItemCommand(object source, Telerik.Web.UI.GridCommandEventArgs e)
    {
        if (e.CommandName == RadGrid.ExportToExcelCommandName)
        {
            RadGrid1.MasterTableView.GetColumn("ColumnUniqueName").Visible = false;
        }
    }

Regards,
Princy.

[Pooya]

Thanks :), it's sorted.

I have another issue that when I export the grid, it only exports the page which is shown whereas I'd need to export all the data of all pages.

I set the IgnorePaging = true but didn't help.

?

[Daniel]

Hello Pooya,

This usually happens when using simple data-binding. Please consider using advanced data-binding or datasource control instead.
Simple data-binding
Advanced data-binding

Best regards,
Daniel
the Telerik team