Read XLSX in Node.js

slurp-xlsx.js

const XLSX = require("xlsx"); // 0.18.5

const workbook = XLSX.readFile("foo.xlsx", { cellDates: true });
const sheetName = workbook.SheetNames[0];
const worksheet = workbook.Sheets[sheetName];
const data = XLSX.utils.sheet_to_json(worksheet, { defval: "" });
console.log(data);

stream-xlsx-async.js

const { getXlsxStream } = require("xlstream"); // ^2.5.5

(async () => {
  try {
    const stream = await getXlsxStream({
      filePath: "/Users/greg/Downloads/test_test.xlsx",
      sheet: 0, // or: "Some sheet name"
      withHeader: true,
      ignoreEmpty: true,
    });

    for await (const row of stream) {
      console.log(row.formatted.obj);
    }

    console.log("Done.");
  } catch (err) {
    console.error("Error:", err);
  }
})();

stream-xlsx.js

const { getXlsxStream } = require("xlstream"); // ^2.5.5

(async () => {
  const stream = await getXlsxStream({
    filePath: "/Users/greg/Downloads/test_test.xlsx",
    sheet: 0, // or: "Some sheet name"
    withHeader: true,
    ignoreEmpty: true,
  });

  stream.on("data", (row) => {
    console.log(row.formatted.obj);
  });

  stream.on("end", () => {
    console.log("Done.");
  });

  stream.on("error", (err) => {
    console.error("Error:", err);
  });
})();