How to read a list of sheets from a Spreadsheet

It seems I can allow external modules and get them via:

const { read: xlsxRead } = require('xlsx');

const data = items[0].binary.data;

workbook = xlsxRead(data.data);

return workbook.SheetNames.map((s) => {
  return {
    json: {
      name: s,
    }
  }
});
6 Likes