Export RadGrid to Excel

[Atif]

I am Exporting RadGrid with aprox 40000 records to excel. But only 100 records are showing in Excel file. which is record of first 10 Pages in RadGrid. Here's my code.

 

protected void ImageButton_Click(object sender, ImageClickEventArgs e)
    {
        RadGrid1.ExportSettings.Excel.Format = GridExcelExportFormat.Html;
        RadGrid1.ExportSettings.IgnorePaging = true;
        RadGrid1.DataBind();
        
        RadGrid1.ExportSettings.ExportOnlyData = true;
        //RadGrid1.ExportSettings.OpenInNewWindow = true;
        RadGrid1.MasterTableView.ExportToExcel();
    }

 

 

RadGrid :

<telerik:RadGrid ID="RadGrid1" runat="server" AllowPaging="true" PageSize="10" GridLines="None"   >
            
            <ClientSettings>
                <Scrolling AllowScroll="true" UseStaticHeaders="true" />
                <Virtualization EnableVirtualization="true"  />
            </ClientSettings>
        </telerik:RadGrid>

[Viktor Tachev]

Hello Atif,

In the provided code the RadGrid control is using simple data binding. We strongly recommend using advanced data binding when exporting data from RadGrid.

Please remove all calls to DataBind() and use the NeedDataSource event or a declarative DataSource control to provide data for RadGrid.


Regards,
Viktor Tachev
Telerik