Export Excel 'System.OutOfMemoryException' issue with 160,000

[Dev]

Hello Team,
I am using Radgrid, that is having more then 160,000 records with 46 columns. The version I am using is ASP.NET AJAX Q3 2013 SP2 (version 2013.3.1324). Excel version is 2013. Export to excel is not working and generate 'System.OutOfMemoryException". I believe Excel 2013 worksheet size hold close to a million rows. Is there any workaround ? See snippet of my code below. I created the grid dynamically

Can anyone help me out with this? Is there any limitation exporting excel or csv from Radgrid with this record size? 

Thanks

Dan​

     private void CreateDetailGrid()
        {
            GridDetailResults.ID = "GridDetailResults";
            GridDetailResults.Columns.Clear();
            GridDetailResults.AutoGenerateColumns = false;
            GridDetailResults.GridLines = GridLines.Both;
            GridDetailResults.AllowSorting = GridDetailResults.AllowPaging = GridDetailResults.AllowSorting = true;
            GridDetailResults.AllowFilteringByColumn = true;
            GridDetailResults.Skin = "Default";
            GridDetailResults.HeaderStyle.Font.Underline = false;
            GridDetailResults.GroupingSettings.CaseSensitive = false;
            GridDetailResults.EnableLinqExpressions = false;
            GridDetailResults.Height = new Unit("400px");

            //Mastertableview settings
            GridDetailResults.MasterTableView.EnableNoRecordsTemplate = true;
            //GridDetailResults.MasterTableView.ShowHeader = true;
            GridDetailResults.MasterTableView.ShowHeadersWhenNoRecords = false;
            GridDetailResults.MasterTableView.CommandItemSettings.ShowExportToExcelButton = true;
            GridDetailResults.MasterTableView.CommandItemSettings.ShowExportToCsvButton = true;
            GridDetailResults.MasterTableView.CommandItemDisplay = GridCommandItemDisplay.Top;
            GridDetailResults.MasterTableView.CommandItemSettings.ShowAddNewRecordButton = false;
            GridDetailResults.MasterTableView.CommandItemSettings.ShowRefreshButton = false;

            // paging style
            GridDetailResults.MasterTableView.PagerStyle.AlwaysVisible = true;
            GridDetailResults.MasterTableView.PagerStyle.PageSizeControlType = PagerDropDownControlType.RadDropDownList;

            // Export setting
            GridDetailResults.ExportSettings.HideStructureColumns = true;
            GridDetailResults.ExportSettings.UseItemStyles = true;
            GridDetailResults.ExportSettings.IgnorePaging = true;          
            GridDetailResults.ExportSettings.OpenInNewWindow = true;
            GridDetailResults.ExportSettings.Excel.Format = GridExcelExportFormat.Html;            
            GridDetailResults.ExportSettings.ExportOnlyData = true;


            //Events
            GridDetailResults.NeedDataSource += GridDetailResults_OnNeedDataSource;


            GridDetailResults.ItemStyle.BackColor = Color.FromName("#DFDFDF");
            GridDetailResults.HeaderStyle.BackColor = Color.FromName("#FFFFFF");
            GridDetailResults.HeaderStyle.ForeColor = Color.FromName("#767676");
            GridDetailResults.AlternatingItemStyle.BackColor = Color.FromName("#FFFFFF");
            GridDetailResults.HeaderStyle.HorizontalAlign = HorizontalAlign.Left;
            GridDetailResults.FilterItemStyle.HorizontalAlign = HorizontalAlign.Left;

            GridDetailResults.ClientSettings.Scrolling.AllowScroll = true;
            GridDetailResults.ClientSettings.Scrolling.SaveScrollPosition = true;
            GridDetailResults.ClientSettings.Scrolling.UseStaticHeaders = true;
            GridDetailResults.ClientSettings.Scrolling.FrozenColumnsCount = 2;                 


            if (AllDimTable == null)
                AllDimTable = BusMethods.GetAllDimList();

 

[Jayesh Goyani]

Hello,

Please check the below link.

http://docs.telerik.com/devtools/aspnet-ajax/controls/grid/functionality/exporting/overview#exporting-a-large-amount-of-data​

Thanks,

Jayesh Goyani

[Dev]

What is the maximum record I can export using Radgrid then ? I can't go beyond 65,000 leave alone 160,000?

[Maria Ilieva]

Hi,

I would suggest you to see the forum post below for more information on this matter:
http://www.telerik.com/forums/export-to-excel-limit

Regards,
Maria Ilieva
Telerik