Loading local Excel workbook with node

Loading local Excel workbook with node

Posted by: ross.hulford on 23 February 2023, 8:48 am EST

• 

  ross.hulford

  • Post Options:
  • Link
    Copy

  Posted 23 February 2023, 8:48 am EST - Updated 11 January 2024, 2:40 pm EST

  Using this example

  https://www.grapecity.com/blogs/how-to-generate-excel-spreadsheets-in-nodejs

  I am trying to load a local excel workbook and get sheet but it does not load. Can this be done in node?

  [code] const data = fs.readFileSync(‘./mysheet.xlsx’, ‘utf-8’);

  excelIO.open(data.buffer,  data => {
      wb.fromJSON(data);
      var sheet = wb.getSheet(0);
      console.log(sheet)
  
  },
  err => {
      console.log(err)
  }
  );[/code]
  

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 27 February 2023, 8:25 am EST

  Dear Ross,

  I hope this message finds you well. It seems like you are using spreadJS so I wanted to follow up on the issue you reported with our blog steps. Despite our efforts, we were unable to replicate the issue on our end. In order to assist you better, could you kindly provide us with a minimal working sample that replicates the issue? This would allow us to investigate the issue further and provide you with the necessary assistance.

  Additionally, I wanted to remind you to ensure that you are using a valid license key with your application. This is crucial in ensuring that your application is functioning properly.

  Thank you for your prompt attention to this matter, and we look forward to hearing back from you soon.

  Best regards,

  Avinash