This is a migrated thread and some comments may be shown as answers.

Item.selected not working while exporting grid to excel

3 Answers 150 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

Atif asked on 11 Mar 2016, 11:59 AM

Hello,

I am trying to export only selected rows in excel but while exporting, item.selected is always returning false in ItemCommand, GridExporting

case "ExportToExcel":

e.Canceled = true;

GridDataItem item3 = (GridDataItem)e.Item;

if (item3.Selected)

{

string Str = item3["ITEM_ID"].Text.ToString();

}

break;

In GridExporting

protected void rgDeviceApproval_GridExporting(object sender, GridExportingArgs e)

{ foreach (GridDataItem item in this.rgDeviceApproval.MasterTableView.Items)

{

if (item.selected)

{

}

3 Answers, 1 is accepted

answered on 14 Mar 2016, 09:54 AM

Hi Atif,

If you have enabled paging with IgnorePaging export property set to "true", the selected items will be cleared within the OnGridExported event, because the control will rebind in order to retrieve all items before the export. If the IgnorePaging is set to "false", you can set the Visible property of the non-selected items:

protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)

{

if (e.CommandName == RadGrid.ExportToExcelCommandName)

{

foreach (GridDataItem item in RadGrid1.Items)

{

if (!item.Selected)

{

item.Visible = false;

}

For more information regarding the export functionality, please refer to our documentation:

http://docs.telerik.com/devtools/aspnet-ajax/controls/grid/functionality/exporting/overview

Hope this helps.

Regards,
Konstantin Dikov
Telerik

Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.