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.
Unfortunately, activation email could not send to your email. Please try again.

Large spreadsheet support

Thread ID:

Created:

Updated:

Platform:

Replies:

125650 Aug 31,2016 02:27 AM Sep 6,2016 09:02 AM JavaScript 1
loading
Tags: ejSpreadSheet
Gabriel Axel
Asked On August 31, 2016 02:27 AM

Greetings,

I'm trying to import different spreadsheets, and with the attached one, which has 50,000 rows, the import process just hangs at http://js.syncfusion.com/demos/web/spreadsheet/default.html . Locally I get a timeout error. I tried adding HttpContext.Current.Server.ScriptTimeout = 60; at the beginning of my Web API import endpoint, but it didn't seem to help - still timed out after a few seconds. Can this be configured to support larger files? Is there a recommended file size beyond which I should not try to import spreadsheets?

Thanks.

Attachment: SampleXLSFile_6800kb.xlsx_2fdb1109.zip

Shanmugaraja K [Syncfusion]
Replied On September 6, 2016 09:02 AM

Hi Gabrial, 

Thanks for using Syncfusion products, 

Query 1: the import process just hangs the browser. 

We have checked the reported issue with your attached excel file. We are unable to reproduce your reported issue, the excel file is loaded fine. We have created simple sample in Essential studio Vol2 Sp1(14.2.0.28) with your requirement and the same can be downloaded from the below link. 


Could you please try the attached sample and get back to us with more information or by reproducing the issue in the above sample, so that we could sort out the cause of the issue and provide you with solution. 

Query 2: Is there a recommended file size beyond which I should not try to import spreadsheets?  

We have analyzed your query with the attached excel file, we would like to let you know that we have passed model of the excel file from the server to client side by JSON string. It will import the file based on the JSON string’s limit irrespective of the file size and the JSON string is based on the rows, columns and cell formatting only. In your case 50,000 rows and 10 columns is imported successfully, which is demonstrated in the above attached sample. 

Regards, 
Shanmugaraja K 


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.

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.

;