[Solved] Exporting selected items of the grid from Multiple Pages

[Dev]

Hi,

How can I achieve exporting the items of the grid from Multiple Pages. For example if I have a grid and I selected 3 items from page1 , 5 items from page 2 and 10 items from page 7. How do I export only the items that I have selected without any performance issues. I have custom paging enabled.

Thanks,

[Eyup]

Hello,

You can use the following approach:

Copy Code

List<int> selectedIndexes = new List<int>();
protected void Button1_Click(object sender, EventArgs e)
{
    ExportToExcel();
}
private void ExportToExcel()
{
    dgReconcileData.ExportSettings.IgnorePaging = true;
    dgReconcileData.ExportSettings.OpenInNewWindow = true;
    dgReconcileData.ExportSettings.OpenInNewWindow = true;

    foreach (string index in dgReconcileData.SelectedIndexes)
    {
        selectedIndexes.Add(int.Parse(index));
    }
    dgReconcileData.MasterTableView.ExportToExcel();
}
protected void dgReconcileData_ItemDataBound(object sender, GridItemEventArgs e)
{
    if (selectedIndexes.Count > 0 && e.Item is GridDataItem)
    {
        e.Item.Display = selectedIndexes.Contains(e.Item.ItemIndex);
    }
}

That should do the trick. Please give it a try and let me know about if it works for you.

Greetings,
Eyup
the Telerik team