Opening workbook using fromJSON takes over a minute

Opening workbook using fromJSON takes over a minute

Posted by: dean.kinnear on 25 September 2024, 12:19 pm EST

• 

  dean.kinnear

  • Post Options:
  • Link
    Copy

  Posted 25 September 2024, 12:19 pm EST

  Please find attached workbook.

  Opening a workbook using fromJSON in version 17.1.6 takes over a minute.
  
  Version 17.0.9 took around 20 seconds for same workbook.

  Thanks,
  
  Dean Kinnear

  template.zip

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 26 September 2024, 2:14 am EST - Updated 26 September 2024, 2:19 am EST

  Hi,

  As per my understanding, loading the JSON using the fromJSON method in version 17.1.6 is taking around a minute, whereas in version 17.0.9, it was taking approximately 20 seconds.

  I tried replicating this behavior on my end with the provided information but was unable to do so. In my tests, after importing the Excel file and then loading the JSON, the time was around 2.6 seconds in version 17.1.6 (this time is specifically for loading with fromJSON, excluding the import time). In version 17.0.9, the loading time was approximately 2.5 seconds. Please refer to the attached GIF “Steps.gif” and the sample provided below.

  GIF:

  Sample: https://jscodemine.mescius.io/share/vrg_r3gm5EqpdVerJQFUtA/?IsEmbed=false&Theme=Unset&PreviewDirection=0&IsEditorShow=true&IsExplorerShow=true&IsPreviewShow=true&IsConsoleShow=true&IsRunBTNShow=false&IsResetBTNShow=false&IsOpenInCodemineBTNShow=false&PanelWidth=20&PanelWidth=50&PanelWidth=30&defaultOpen={"OpenedFileName"%3A["%2Findex.html"%2C"%2Fpackage.json"%2C"%2Fsrc%2Fapp.js"]%2C"ActiveFile"%3A"%2Findex.html"}

  To assist you better, could you provide a sample along with the steps to replicate the behavior you’ve observed? Alternatively, you can modify the existing sample. Additionally, it would be helpful if you could share a GIF or video illustrating the issue.

  Regards,
  
  Priyam