Export selected rows

[Joslyn]

Hi,
I tried many codes that showed how to make only selected rows export, but im not able to get it to work.can someone guide me on this.I want to export to excel.

[Princy]

Hi Joslyn,

When exporting selected rows,make sure you have set IgnorePaging=false.Please try the sample code snippet.

ASPX:

<telerik:RadGrid ID="RadGrid1" runat="server" OnNeedDataSource="RadGrid1_NeedDataSource"
    AutoGenerateColumns="false" AllowMultiRowSelection="true">
    <MasterTableView>
        <Columns>
            <telerik:GridBoundColumn DataField="Column1" HeaderText="Column1">
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn DataField="Column2" HeaderText="Column2">
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn DataField="Column3" HeaderText="Column3">
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn DataField="Column4" HeaderText="Column4">
            </telerik:GridBoundColumn>
            <telerik:GridBoundColumn DataField="Column5" HeaderText="Column5">
            </telerik:GridBoundColumn>
        </Columns>
    </MasterTableView>
    <ClientSettings>
        <Selecting AllowRowSelect="true" />
    </ClientSettings>
</telerik:RadGrid>
<asp:Button Text="Export to Excel" ID="Button1" OnClick="Button1_Click" runat="server" />

C#:

protected void RadGrid1_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
    DataTable table = new DataTable();
    table.Columns.Add("Column1");
    table.Columns.Add("Column2");
    table.Columns.Add("Column3");
    table.Columns.Add("Column4");
    table.Columns.Add("Column5");

    for (int i = 0; i < 20; i++)
    {
        table.Rows.Add("Col1Row" + i, "Col2Row" + i, "Col3Row" + i, "Col4Row" + i, "Col5Row" + i);
    }
    RadGrid1.DataSource = table;
}
protected void Button1_Click(object sender, EventArgs e)
{
    foreach (GridDataItem item in RadGrid1.MasterTableView.Items)
    {
        if (!item.Selected)
        {
            item.Visible = false;
        }
    }
    RadGrid1.ExportSettings.IgnorePaging = false;
    RadGrid1.ExportSettings.FileName = "Document";
    RadGrid1.MasterTableView.ExportToExcel();
}

Thanks,
Princy