SpreadJS Excel Load Error response Question

SpreadJS Excel Load Error response Question

Posted by: quiz on 14 March 2018, 3:33 am EST

• 

  quiz

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 14 March 2018, 3:33 am EST

  Dear whom it may concern,
  
  We are Unidocs Inc., developing PDF and e-document solutions in South Korea. During end of last year, we’ve purchased a developer’s license and a domain-distribution license of SpreadJS due to one of our customer’s request for online Excel viewer. We have been developing our solution in conformance with the customer’s requirements, using SpreadJS API. Currently we are expecting to include the solution as one of our new product line-up upon marking an end to the on-going project. However, we are facing a few technical difficulties with regard to distributing our SpreadJS-applied product.
  
  We have inquired GrapeCity Korea for technical support earlier, but unfortunately there are remaining issues followed by a few inquiries with regard to SpreadJS as below.
  
  

  1. Due to unknown reason, certain excel file fails to be opened from time to time.
  2. Such intermittent failures may be reasonable, but we need a solution for handling such exception cases.
  3. Upon failure to open the excel file, the entire browser freezes and the user has to close all web-browsers in order to skip/proceed with the work.
     
     
  4. Is setting for TimeOut of the excel file response available in SpreadJS? or
  5. Is there any way to return alert/error message to the user when there’s no response from the excel file or the excel file fails to open? or
  6. Is there any way to bypass the failure, so that the user can keep up with his/her web-browser task without closing the entire browsers upon failure?
     
     Currently, the browser-freezing status keeps bothering the customer, which delays our final delivery of the newly developed product. If there are any solutions available for the conditions mentioned above, we hope to hear from you as soon as possible.
     
     God bless, and have a nice day.
• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 15 March 2018, 11:02 am EST

  Hello,

  There is no direct mechanism in SpreadJS to inform about Excel import failure. You can get the You can use the SetTimeout method while importing the excel file and if it takes longer than the assigned time you can cancel the import. Please have a look at the attached sample.
  
  I will also pass this onto the dev team for further investigation and let you know if we find anything more appropriate.

  Thanks,
  
  Deepak Sharma
  
  SpreadJSCancelImport.html.zip

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 20 March 2018, 4:55 am EST

  Hello,

  I have got an update on all the 3 questions above from the development team:

  1. Is setting for TimeOut of the excel file response available in SpreadJS?
     
     Answer:
     
     No, currently there is no functionality available currently to set TimeOut. You can use the work-around I provided.

  2. Is there any way to return alert/error message to the user when there’s no response from the excel file or the excel file fails to open?
     
     Answer:
     
     If the excel file import failed, there will be an error callback.
     
     http://help.grapecity.com/spread/SpreadSheets11/webframe.html#SpreadJS~GC.Spread.Excel.IO~open.html

  3. Is there any way to bypass the failure, so that the user can keep up with his/her web-browser task without closing the entire browsers upon failure?
     
     Answer:
     
     If you mean to restore the running scene but ignore the failed ExcelIO operation, you could use the error callback method. But for TimeOut till now, there is no direct solution.

  Thanks,
  
  Deepak Sharma