Export To Excel Only Selected Rows

[Chamira]

How can i export only the selected rows of  a grid ??

and when i exported a grid with a clientsideselecting column the checkboxes appear..
How can i avoid that..

Thanks in advance...

[Princy]

Hello Chamira,

You can try out the following code to export only the selected rows in the grid and also to avoid exporting checkboxes, set the ExportSettings.ExportOnlyData property to true.
cs:

protected void Button1_Click(object sender, EventArgs e)
    {
        foreach (GridDataItem item in RadGrid1.Items)
        {
            if (item.Selected==false)
            {
                item.Visible = false;
            }
        }
        RadGrid1.ExportSettings.ExportOnlyData = true;
        RadGrid1.ExportSettings.OpenInNewWindow = true;
        RadGrid1.MasterTableView.ExportToExcel();
    }

Thanks
Princy.

[Chamira]

thanks a lot princy.. it worked like a miracle..

da only thing i had to do was disable da visible property of the columns coz i had some template columns in there..

thanks