Import xls in Spread Js - GC.Spread.Excel.IO() open method

Import xls in Spread Js - GC.Spread.Excel.IO() open method

Posted by: pooja.bansal on 27 August 2020, 11:03 pm EST

• 

  pooja.bansal

  • Post Options:
  • Link
    Copy

  Posted 27 August 2020, 11:03 pm EST

  We are using Spread Js version-
  
  gc.spread.sheets.all.12.2.4.min.js
  
  gc.spread.excelio.12.2.4.min.js

  Code Snippet -
  
  let activeSheet: any;
  
  let spread = new GC.Spread.Excel.IO();
  
  if (spread && file) {
  
  spread.open(file, (json) => {
  
  setTimeout(() => {
  
  activeSheet = json.sheets[activeSheetName];
  
  resolve(activeSheet);
  
  }, 0);
  
  }, (error) => {
  
  resolve(“Not Found”);
  
  });

    }
  

  We are able to import file with extension .xlsx.
  
  However, when we are not able to read(open) file with xls extension.

  Is there any way to make xls extension file working with the above import code?

  Regards
  
  Pooja Bansal

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 30 August 2020, 5:29 pm EST

  Hi Pooja,

  We are sorry but SJS only supports xlsx extension officially. Using other formats could have issues. We would recommend you to use only the .xlsx files.

  Regards
  
  Sharad.