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();