Export to Excel option

[KS]

Export to excel option is working properly with grid with pages

I have set page size to 50 and actual rows are 1000+
Now when I take use export option, Excel is showing records for first page only and some distorted data in the bottom.

I have use following code:

private void ExportGridToExcel(Telerik.Web.UI.RadGrid radgrid1)
    {
        radgrid1.PageSize = 1000;
        radgrid1.Rebind();
        radgrid1.MasterTableView.ExportToExcel();
        radgrid1.PageSize = 50;
        radgrid1.Rebind();
    }

It also not working..

[Shinu]

Hello,

You can set IgnorePaging property to true to avoid the paging before Exporting.

C#:

protected void Button2_Click(object sender, EventArgs e)
 {
     RadGrid1.ExportSettings.IgnorePaging = true;
     RadGrid1.MasterTableView.ExportToExcel();
 }

Please refer the following documentation for more on this.
http://www.telerik.com/help/aspnet-ajax/grdexport.html

Thanks,
Shinu.