We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on : November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Asp.Net Web Forms, Using Spreadsheet Control, Large Data Objects

Thread ID:

Created:

Updated:

Platform:

Replies:

127185 Nov 1,2016 01:00 PM UTC Nov 4,2016 12:40 PM UTC ASP.NET Web Forms 4
loading
Tags: Spreadsheet
Will Smith
Asked On November 1, 2016 01:00 PM UTC

I was hoping that I would be able to use the spreadsheet control for web forms. The problem, I've run into, is we have huge data objects, and the control uses serialization which has size limits. I've search the forum and attempted to use some of the methods outline for large data. I've run into max size limit and out of memory issues. Can you suggest anything else I might try?

Shanmugaraja K [Syncfusion]
Replied On November 2, 2016 11:46 AM UTC

Hi Will Smith, 

Thank you for using Syncfusion products, 

Before we start to providing you a solution please provide the below details, 

1.       Are you import excel file by using import option (ImportUrl or ribbon File -> open)? if so, how many rows and columns you are using? 
2.       What are all the formatting (font color, background color, formula, merge cell, wrap text etc..) you are using in your project? Since, import file is based on the JSON string’s limit and JSON string based on the rows, columns and cell formatting only. 
3.       If possible, provide dummy excel file which contains the same rows, columns and features used in your project. 
  
The information provided would be great help to resolving the issue. 

Regards, 
Shanmugaraja K  


Will Smith
Replied On November 2, 2016 12:27 PM UTC

I've tried all the above, it would be ideal if I could load it in code behind via:

List<mycollection> lst = GetMyList();
this.Spreadsheet.Sheets.Add(new Syncfusion.JavaScript.Models.Sheet()
{
      Datasource = lst
});

The code works fine as long as I limit it to less than 2000 rows. I tried custom serialing and I get out of memory if I go more than 2000 rows.




Will Smith
Replied On November 2, 2016 12:32 PM UTC

I'm having problems attaching the dummy file, trying again.

List<mycollection> lst = GetMyList();
this.Spreadsheet.Sheets.Add(new Syncfusion.JavaScript.Models.Sheet()
{
      Datasource = lst
});

The code works fine as long as I limit it to less than 2000 rows. I tried custom serialing and I get out of memory if I go more than 2000 rows.

Attachment: DummyFile_c650a4e7.rar

Silambarasan I [Syncfusion]
Replied On November 4, 2016 12:40 PM UTC

Hi Will Smith, 
 
Thanks for your update. 
 
We considered this as a defect and a new support incident has been created under your account to track the status of this requirement.  Please log on to our support website to check for further updates.  
 
 
 
Regards, 
Silambarasan I 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;