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

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

  • 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
  • Replied 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.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels