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>