Upgrade to gcexcel v4.1.0 & SpreadJS (v13&v14) JSON parse error in web browser

Upgrade to gcexcel v4.1.0 & SpreadJS (v13&v14) JSON parse error in web browser

Posted by: jk on 7 June 2021, 5:37 am EST

• 

  jk

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 7 June 2021, 5:37 am EST

  Hi,

  I use both gcexcel and spreadjs together. Server side gcexcel inserts data in a worksheet, then spreadjs displays it in a web browser.

  It worked with spreadjs 13.0.7 & 14.0.10 and gcexcel v3.1.0.
  
  Once I upgraded gcexcel to v4.1.0 JSON.parse wouldn’t handle json produced by gcexcel v4.1.0 anymore.

  Please help ASAP. This is a blocking issue.

  This code:

  jsonForm = JSON.parse($scope.jsonSpread);
  

  Produces this error:

  angular.js:10071 SyntaxError: Unexpected token , in JSON at position 3411
      at JSON.parse (<anonymous>)
  

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 8 June 2021, 7:20 pm EST

  Hello,

  Could you please share the json produced using GcExcel v3.1.0, we will look into this issue thereon.

  Thanks,
  
  Reeva