Large spreadsheet support

[Gabriel Axel]

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]

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. 

Sample: http://www.syncfusion.com/downloads/support/forum/125650/ze/SpreadsheetWebserviceSample-40383019  

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