Import excel file issue

Import excel file issue

Posted by: arun.rudrangi on 1 March 2018, 3:33 am EST

• 

  arun.rudrangi

  • Post Options:
  • Link
    Copy

  Posted 1 March 2018, 3:33 am EST

  Hi there we were able to import spreedsheet using spreadjs but this is taking 7.5 minutes to load as this file has 20 tabs and 10K cells data is there any property or some code helps improve performance on this?

  sad part is to edit each cell it takes same amount of time is there any way we can recognise only changed cells and updated them on server instead of rendering whole file again?

• 

  abdias.michael

  

  • Post Options:
  • Link
    Copy

  Posted 4 March 2018, 11:20 pm EST

  Can you please attach the spreadsheet you are importing using SpreadJS? Also, please mention the version of SpreadJS you’re using so I can test it with the same version.

  Thanks

• 

  ian.scriven

  • Post Options:
  • Link
    Copy

  Posted 7 March 2018, 2:50 pm EST

  Any chance you’re using the RANDBETWEEN function in your spreadsheet?

  I’ve just seen a similar issue, that I was able to isolate to the use of RANDBETWEEN. Removing these function calls lowers the load/recalc time for this particular workbook from minutes to 1 or 2 seconds. Maybe an issue with how/when volatile functions are (re)calculated?

• 

  abdias.michael

  

  • Post Options:
  • Link
    Copy

  Posted 7 March 2018, 11:20 pm EST

  Thank you for sharing your solution with us. Probably it’ll help Arun or other developers who are working with the RANDBETWEEN function.