This is a migrated thread and some comments may be shown as answers.

Export to Excel limit

36 Answers 2022 Views

Grid

This is a migrated thread and some comments may be shown as answers.

36 Answers, 1 is accepted

answered on 02 Sep 2008, 07:22 AM

Thanks for your replies, Princy and Daniel.

Actually, the first wall that I've hit while playing around with the exports (I attempted to export to csv as it was recommended in one of the various solutions) is the fact that the system cannot seem to process the export at such a large volume.

Here are some sites detailing the kind of issue I'm dealing with (if anyone needs a reference):
http://forums.asp.net/p/1281278/2449394.aspx
http://discuss.fogcreek.com/dotnetquestions/default.asp?cmd=show&ixPost=4787

In regards to office 2007, unfortunately I can't force my users to upgrade as the current standard is 2003.

With splitting the results, would that mean I would have to develop a function to do it? Or is there a way, using Rad tools, to bind a grid > export to a sheet, create a new sheet within the same work book > bind grid > export etc or would I have to create a new worksheet at each export?

answered on 26 Jun 2009, 06:43 PM

Hi,

I'm not sure why but I'm getting OutOfMemoryException when I try to export records. But it is not as large as 65k. The actual count is 32787. So I'm not sure why this is happening.

    
            [OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.] 
        
               System.String.GetStringForStringBuilder(String value, Int32 startIndex, Int32 length, Int32 capacity) +34 
        
               System.Text.StringBuilder.GetNewString(String currentString, Int32 requiredLength) +73 
        
               System.Text.StringBuilder.Append(Char[] value, Int32 startIndex, Int32 charCount) +115 
        
               System.Text.StringBuilder.AppendFormat(IFormatProvider provider, String format, Object[] args) +235 
        
               Telerik.Web.UI.GridExcelBuilder.Abstract.ElementBase.AppendAttributes(StringBuilder sb) +396 
        
               Telerik.Web.UI.GridExcelBuilder.DataElement.AppendAttributes(StringBuilder sb) +62 
        
               Telerik.Web.UI.GridExcelBuilder.Abstract.ElementBase.Render(StringBuilder sb) +14 
        
               Telerik.Web.UI.GridExcelBuilder.CellElement.RenderChildElements(StringBuilder sb) +21 
        
               Telerik.Web.UI.GridExcelBuilder.Abstract.ElementBase.Render(StringBuilder sb) +23 
        
               Telerik.Web.UI.GridExcelBuilder.RowElement.RenderChildElements(StringBuilder sb) +99 
        
               Telerik.Web.UI.GridExcelBuilder.Abstract.ElementBase.Render(StringBuilder sb) +23 
        
               Telerik.Web.UI.GridExcelBuilder.Abstract.ElementBase.Telerik.Web.UI.GridExcelBuilder.Abstract.IElement.Render(StringBuilder sb) +4 
        
               Telerik.Web.UI.GridExcelBuilder.TableElement.RenderChildElements(StringBuilder sb) +549 
        
               Telerik.Web.UI.GridExcelBuilder.Abstract.ElementBase.Render(StringBuilder sb) +23 
        
               Telerik.Web.UI.GridExcelBuilder.WorksheetElement.RenderChildElements(StringBuilder sb) +28 
        
               Telerik.Web.UI.GridExcelBuilder.Abstract.ElementBase.Render(StringBuilder sb) +23 
        
               Telerik.Web.UI.GridExcelBuilder.WorkBook.RenderChildElements(StringBuilder sb) +295 
        
               Telerik.Web.UI.GridExcelBuilder.WorkBook.Render(StringBuilder sb) +32 
        
               Telerik.Web.UI.Grid.Export.TableViewExporter.ExcelExportRenderForm(HtmlTextWriter nullWriter, Control form) +2966 
        
               System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +2065835 
        
               System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +24 
        
               System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) +59 
        
               System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) +68 
        
               System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25 
        
               System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121 
        
               System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) +37 
        
               Telerik.Web.UI.Grid.Export.TableViewExporter.ExcelExportRenderPage(HtmlTextWriter nullWriter, Control page) +102 
        
               System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +2065835 
        
               System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +24 
        
               System.Web.UI.Page.Render(HtmlTextWriter writer) +26 
        
               System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25 
        
               System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121 
        
               System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22 
        
               System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1896

I hope someone has a solution as I'm confused about what to do here. It works fine if I split them as 1000 records but the users do not want to do it through multiple excel files.

answered on 10 Dec 2009, 06:30 PM

Hello Jaroslav,

I believe there is no way to export such enormous amount of data.

Please try the following: Set IgnorePaging to false to display all the 50000 items in 30 columns in your browser. Then run the task manager and let me know how much memory is occupied by its process.

For testing purposes, I tried this with 50,000 items and just 3 columns - the result was 470MB footprint. Please notice, that I'm the only user exporting at this time - imagine what will happen if there are 5 users, each of them exporting 50000 items in 30 columns simultaneously.

I hope my explanation was helpful.

Best regards,
Daniel
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

answered on 28 Oct 2010, 02:23 PM

Hello Kurt,

RadGrid is capable to export limited quantities of data. Should you need to export large datasources it would be better to use a separate exporting component, reporting control, or your own exporting library (you could use NPOI to generate the file) that fetches the data directly from the data source.

Even if we theoretically improve the speed and memory footprint three times (just an example) you will get the same exception if you have three users that export the same data in the same time. This is why we do not recommend to use RadGrid in such scenarios.

Best regards,
Daniel
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

answered on 22 Dec 2010, 04:02 AM

Hi,

I implemented the paging technique and allowed them to download the report partially. They tried it until now but now the database has grown too big to do it partially. They are asking me for a solution or else they will take the project to someone else.

The excel sheet is about 60MB when generated. And Microsoft Excel 2007 comes with 1,048,576 rows by 16,384 columns. So why is it still generating in the old 2003 version? Why can't we generate it in xlsx format? That should fix this problem shouldn't it?

Also, someone told me to try serliazing the object before putting it in the stream to convert it. I'm wondering if it is being serialized here internally before convert.

I would really appreciate it if you can get back to me ASAP. Look forward to your response.

Kind Regards,
JB

answered on 09 Nov 2011, 05:29 PM

Hello Telerik Team,

I am not sure exporting issue is constrained to Excel 2003 or 2007.
I am trying to export out a huge amount of data to a PDF file from the Rad Grid.
But i end up with the

Exception of type 'System.OutOfMemoryException' was thrown.

My Server has about 4 GB of available RAM, the w3wp.exe process only consumes 1.4 Gb (1,040,708 K) when i got this error.

Hence I notice that, although the server has a lot more memory to consume, the export crashes after consuming about 1.4 GB.
i prioritised w3wp.exe instance to use Real Time Memory through Task Manager, but that doesn't help either.

What can I do to for this.
I am trying to export about 500K rows with 5 columns of data. What would you suggest I do for this ?

answered on 10 Sep 2019, 08:13 AM

Hi Kalai,

RadGrid provides various excel formats:
https://demos.telerik.com/aspnet-ajax/grid/examples/functionality/exporting/excel-export/defaultcs.aspx
https://demos.telerik.com/aspnet-ajax/grid/examples/functionality/exporting/pdf-export/defaultcs.aspx

But I'm afraid it is not suitable for exporting large amount of data:
http://docs.telerik.com/devtools/aspnet-ajax/controls/grid/functionality/exporting/overview#export-large-amount-of-data
http://www.telerik.com/forums/system-outofmemory-exception-while-exporting-telerik-grid-data#6viUZtAzT0SLWwX3EfTauQ

If you want to reduce the exporting time, the only viable option would be to export only a portion of the items by removing or disabling the IgnorePaging property.

You can also check RadSpreadStreamProcessing for building the data in the exported file manually, but please bear in mind this would be a custom endeavor and beyond our support scope:
https://demos.telerik.com/aspnet-ajax/spreadstreamprocessing/large-document-export/defaultcs.aspx
https://docs.telerik.com/devtools/aspnet-ajax/controls/spreadstreamprocessing/overview.html

I really want to to offer you something feasiable, but I'm afraid it won't be possible in this case. The count of records is too much and this kind of massive exporting is just not supported with RadGrid.

Regards,
Eyup
Progress Telerik

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.

answered on 14 Feb 2025, 12:07 PM

When grid contains more than 30k records then i am getting 500 Error.

This is my code

@(Html.ReportsGrid
<apexportal.WebService.Models.AuditReportResult>()
    .HtmlAttributes(new { @style = "height: 500px;" })
    .Name("AuditReportGrid")
    .Excel(e => { e.FileName("AuditReport.xlsx").AllPages(true); })
    .Events(e => { e.ExcelExport("excelExportCheck"); })
    .AutoBind(false)
    .DataSource(datasource => datasource
    .Custom()
    .Type("aspnetmvc-ajax")
    .Transport(t => t.Read(r => r.Action("Read", "AuditReport").Data("getAdditionalData")))
    .Schema(s => s
    .Data("Data")
    .Model(model =>
    {
    model.Id(itm => itm.VR_Audit_LogID); //("VR_Audit_LogID");
    model.Field("VendorID", typeof(string));
    model.Field("ActionTime", typeof(DateTime));
    model.Field("ReviewedDate", typeof(DateTime));
    })
    .Total("Total")
    )
    .ServerSorting(true)
    .ServerPaging(true)
    .ServerFiltering(true)
    .ServerGrouping(false)
    .ServerAggregates(false)
    .Events(events => events.Error("error_handler"))
    )
    .Columns(columns =>
    {
    columns.Bound(portal => portal.VR_ID).Title("VR ID".Translate())
    .HeaderHtmlAttributes(new { @class = "NumericHeaderAlign" }).HtmlAttributes(new { @class = "NumericRowAlign" }).Width(180)
    .Filterable(x => x.Cell(y => y.Template("NumericFilter")));
    if (userACL.IsRegistrationEnabled &&!userACL.IsCustomerRegistrationEnabled)
    {
    columns.Bound(portal => portal.VendorID).Title("Vendor ID".Translate())
    .HeaderHtmlAttributes(new { @class = "StringHeaderAlign" }).HtmlAttributes(new { @class = "StringRowAlign" }).Width(150);
    }
    if (userACL.IsCustomerRegistrationEnabled)
    {
    columns.Bound(portal => portal.VendorID).Title("Entity ID".Translate())
    .HeaderHtmlAttributes(new { @class = "StringHeaderAlign" }).HtmlAttributes(new { @class = "StringRowAlign" }).Width(150);
    }
    columns.Bound(portal => portal.CompanyName).Title("Company Name".Translate())
    .ClientTemplate("#=buildCompanyNameLink(CompanyName, '" + @Url.Action("GetCompanyUrl") + "')#")
    .HeaderHtmlAttributes(new { @class = "StringHeaderAlign" }).HtmlAttributes(new { @class = "StringRowAlign" }).Width(200);
    columns.Bound(portal => portal.ModifiedFieldName).Title("Field Name".Translate())
    .HeaderHtmlAttributes(new { @class = "StringHeaderAlign" }).HtmlAttributes(new { @class = "StringRowAlign" }).Width(250);
    columns.Bound(portal => portal.DecryptedOriginalValue).Title("Original Value".Translate())
    .HeaderHtmlAttributes(new { @class = "StringHeaderAlign" }).HtmlAttributes(new { @class = "StringRowAlign" }).Width(150);
    columns.Bound(portal => portal.DecryptedNewValue).Title("New Value".Translate())
    .HeaderHtmlAttributes(new { @class = "StringHeaderAlign" }).HtmlAttributes(new { @class = "StringRowAlign" }).Width(150);
    columns.Bound(portal => portal.ChangedBy).Title("Changed By".Translate())
    .HeaderHtmlAttributes(new { @class = "StringHeaderAlign" }).HtmlAttributes(new { @class = "StringRowAlign" }).Width(150);
    columns.Bound(portal => portal.ChangedByFirstName).Title("Changed By First Name".Translate())
    .HeaderHtmlAttributes(new { @class = "StringHeaderAlign" }).HtmlAttributes(new { @class = "StringRowAlign" }).Width(150);
    columns.Bound(portal => portal.ChangedByLastName).Title("Changed By Last Name".Translate())
    .HeaderHtmlAttributes(new { @class = "StringHeaderAlign" }).HtmlAttributes(new { @class = "StringRowAlign" }).Width(150);
    columns.Bound(portal => portal.RegistrationType).ClientTemplate("#= RegistrationType == null ? '' : TranslateText(RegistrationType) #").Title("Registration Type".Translate())
    .HeaderHtmlAttributes(new { @class = "StringHeaderAlign" }).HtmlAttributes(new { @class = "StringRowAlign" }).Width(150);
    if (userACL.IsCustomerRegistrationEnabled && userACL.IsRegistrationEnabled)
    {
    columns.Bound(portal => portal.ProfileType).ClientTemplate("#= ProfileType == null ? '' : TranslateText(ProfileType) #").Title("Profile Type".Translate())
    .HeaderHtmlAttributes(new { @class = "StringHeaderAlign" }).HtmlAttributes(new { @class = "StringRowAlign" }).Width(150);
    }
    columns.Bound(portal => portal.Action).ClientTemplate("#= Action == null ? '' : TranslateText(Action) #").Title("Action".Translate())
    .HeaderHtmlAttributes(new { @class = "StringHeaderAlign" }).HtmlAttributes(new { @class = "StringRowAlign" }).Width(110);
    //columns.Bound(portal => portal.PRIMARY_KEY).Title("Primary Key".Translate()).HtmlAttributes(new { @style = "white-space: nowrap;" }).Width(110);
    columns.Bound(portal => portal.DataSource).Title("Data Source".Translate())
    .HeaderHtmlAttributes(new { @class = "StringHeaderAlign" }).HtmlAttributes(new { @class = "StringRowAlign" }).Width(110);
    columns.Bound(portal => portal.ActionTime).Title("Action Time".Translate()).Format("{0:G}")
    .HeaderHtmlAttributes(new { @class = "DateHeaderAlign" }).HtmlAttributes(new { @class = "DateRowAlign" }).Width(150);
    columns.Bound(portal => portal.ReviewMode).ClientTemplate("#= ReviewMode == null ? '' : TranslateText(ReviewMode) #").Title("Review Action".Translate())
    .HeaderHtmlAttributes(new { @class = "StringHeaderAlign" }).HtmlAttributes(new { @class = "StringRowAlign" }).Width(110);
    columns.Bound(portal => portal.ReviewedBy).Title("Reviewed By".Translate())
    .HeaderHtmlAttributes(new { @class = "StringHeaderAlign" }).HtmlAttributes(new { @class = "StringRowAlign" }).Width(110);
    columns.Bound(portal => portal.ReviewedDate).Title("Reviewed Date".Translate()).Format("{0:G}")
    .HeaderHtmlAttributes(new { @class = "DateHeaderAlign" }).HtmlAttributes(new { @class = "DateRowAlign" }).Width(150);
    }
    )
    .Filterable(filterable => filterable
    .Extra(false)
    .Operators(operators => operators
    .ForDate(str => str.Clear()
    .IsNotEqualTo("Is not equal to".Translate())
    .IsGreaterThanOrEqualTo("Is after or equal to".Translate())
    .IsGreaterThan("Is after".Translate())
    .IsLessThanOrEqualTo("Is before or equal to".Translate())
    .IsLessThan("Is before".Translate())
    .IsNull("Is Null".Translate())
    .IsNotNull("Is Not Null".Translate()))))
    )
    }

    @Html.GridErrorHandler()
    @Html.GridResizeHandler("AuditReportGrid")
    @CustomHtml.GridContextMenu(Html, "AuditReportGrid")
    @CustomHtml.EnableFormValidation("SearchForm", "searchbtn")

Rumen

commented on 14 Feb 2025, 02:02 PM

Hi Sajid, it looks like you're asking about an issue with a Telerik MVC grid displaying more than 30k records and receiving a 500 error. However, this forum is specifically for RadGrid in ASP.NET AJAX.

I recommend posting your question in the Telerik MVC forums, where the community and support team can provide more relevant assistance. You can find the Telerik MVC forums here: Telerik UI for ASP.NET MVC Forum.

This will ensure you get the best possible help for your issue!

Sajid

commented on 18 Feb 2025, 09:11 AM

Hi Rumen,

I am asking about the downloading more than 50000 records into excel. then i am getting this error.

Rumen

commented on 18 Feb 2025, 10:04 AM

Hi Sajid,

I understand that you're facing an issue while downloading more than 50,000 records into Excel. However, as mentioned earlier, this forum is specifically for RadGrid in ASP.NET AJAX, while your issue relates to Telerik UI for ASP.NET MVC Grid which is a different component.

If you want to export large amount of data with RadGrid follow the instructions in this KB article: Export large amount of data to PDF, XLSX and CSV using the Telerik Document Processing libraries.
For exporting large data with the Kendo UI Grid check this article: Export Grid to Excel with the RadSpreadStreamProcessing Library.

To get the most relevant assistance, I recommend posting your question in the Telerik UI for ASP.NET MVC Forum.

This will ensure you receive help from the right community and support team.