Getting a TypeError: Cannot close a CLOSED writable stream while importing xlsx

Getting a TypeError: Cannot close a CLOSED writable stream while importing xlsx

Posted by: georgeg on 19 March 2025, 3:36 pm EST

• 

  georgeg

  • Post Options:
  • Link
    Copy

  Posted 19 March 2025, 3:36 pm EST - Updated 19 March 2025, 3:41 pm EST

  I am getting an error while trying to use the import feature based on your sample code:
  
  https://developer.mescius.com/spreadjs/demos/features/spreadjs-file-format/overview/purejs

  I am using Visual Studio 2022 and I am getting the following error:
  
  TypeError: Cannot close a CLOSED writable stream… a few clicks later on the Continue button in
  
  Visual Studio and I see this:
  
  TypeError: Failed to execute ‘close’ on ‘WritableStream’: Cannot close a locked stream
  
  Then some times I eventually get the file and sometimes I do not see the file in the spreadsheet control.

  When clicking on the Open button:
  
  

  

  1194×560 29.3 KB

  I have implanted this example into my current code in visual studio 2022 basically the same example found on the link above.

  I am able to choose the file but when I click on the Open button it throws the exception shown.
  
  Also if I import a CSV file it imports that fine, its only puking /throwing the exception durring the import of ANY xlsx file.

  Previously I started playing with this example in a separate project in VSCode it worked fine. no problems. But again this was using the example pretty much exactly as it appears in the example page.
  
  If the xlsx file is large or complicated it will not import the file.
  
  If it is small well with the default settings checked I will be able to click through all the exceptions and see it:

  

  1106×484 72 KB

  I cannot send you my code because it is too big but I can send you the code I was working with in VCCodeSpreadJS_ImportTestBed.zip

  Thanks!
  
  George

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 20 March 2025, 12:18 am EST

  Hi George,

  We are able to replicate the issue with the Visual Studio Version 17.11.5. Also, I was unable to replicate the issue in version V17.10.8 during our testing.

  The developers have mentioned that SpreadJS is a pure JavaScript component, it is only run in the browser with HTML 5 support. The issue is related to the Visual Studio or changes in the newer version, as the same SpreadJS works fine in older visual studio and other code editors such as Visual Studio Code. You could raise the concern with the Visual Studio Support.

  Regards,

  Ankit