excelIO.save on large workbooks causes UI thread to be blocked and lock up

excelIO.save on large workbooks causes UI thread to be blocked and lock up

Posted by: dean.kinnear on 28 July 2023, 12:59 pm EST

• 

  dean.kinnear

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 28 July 2023, 12:59 pm EST

  Any suggestions on how to work around this issue?

  Thanks,
  
  Dean

• 

  chandan.rawat

  

  • Post Options:
  • Link
    Copy

  Posted 31 July 2023, 3:34 am EST

  Hi Dean,

  Could you please provide us with the Excel or json file in which you are facing the issue? This will enable us to find the root cause of the issue and help you accordingly. Also, please specify the SpreadJS version you are using.

  If you are using SpreadJS v16, you may try to export the file using Spread IO module. The new IO module was released in SpreadJS v16.0.0. You can use spread.export() method to export the file.

  Please refer to https://www.grapecity.com/spreadjs/demos/features/spreadjs-file-format/overview/purejs and https://www.grapecity.com/spreadjs/docs/features/spreadjs-file-format for more information about the new Spread IO module.

  Regards

• 

  dean.kinnear

  • Post Options:
  • Link
    Copy

  Posted 8 August 2023, 11:13 am EST

  Here is the template.!Next Gen Template - Dean Based.zip

  Thanks!

• 

  chandan.rawat

  

  • Post Options:
  • Link
    Copy

  Posted 9 August 2023, 5:31 am EST - Updated 9 August 2023, 5:37 am EST

  Hi,

  We are unable to replicate the issue at our end. We tried to replicate the issue by exporting the Excel file shared by you with excelio.save() method. However, we did not encounter any issues.

  Please refer to the attached sample and gif.

  Sample: https://jscodemine.grapecity.com/share/O7V5ThGyl0OBPODRRGCSlQ/?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"%2Fsrc%2Fapp.js"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.js"}

  You may also try the Spread IO module. The Spread IO module was released with SpreadJS v16.0.0. It provides methods spread.import() and spread.export() to import and export the excel files respectively. Please refer to https://www.grapecity.com/spreadjs/demos/features/spreadjs-file-format/overview/purejs and https://www.grapecity.com/spreadjs/docs/features/spreadjs-file-format for more information about SpreadIO module.

  It is important to note that SpreadJS is a web application. So, its performance depends upon the configuration of the host system. The UI may be blocked a bit while exporting to an Excel file as it runs in a single thread.

  

  Regards