Export Subset of Grid Data

[Peter]

I am trying to figure out how to best export a subset of data from a R.A.D. Grid. Specifically, I want to export only the selected items of the grid. It is a paged grid, non-hierarchical. If anyone knows a good way to do this, please let me know.

[Princy]

Hello Peter,

The following code snippet shows how to export only selected items in grid.

C#:

protected void ExportBtn_Click(object sender, EventArgs e)
    {
        foreach (GridDataItem dataitem in RadGrid1.Items)
            {
                dataitem.Visible = dataitem.Selected;
            }
            RadGrid1.ExportSettings.OpenInNewWindow = true;
            RadGrid1.MasterTableView.ExportToExcel(); // exporting to Excel
    }

Thanks,
Princy.

[Peter]

Hi, thanks for you reply.

I tried this and it's not working. During the post-back caused by the button, changes made to the visibility of columns are being reflected in the output. However, changes to the the visibility of grid data items has no effect; it still exports the entire data set.

[Daniel]

Hello Peter,

If you have set IgnorePaging="true" or if you rebind RadGrid manually before exporting, you will have to use the ItemCreated/ItemDataBound event as explained in our documentation:
Word/Excel export (HTML-based)

Best regards,
Daniel
the Telerik team