Get all rows from all sheets in a excel doc as json array

excelSheetsToJsonRows.js

// Get all rows from all sheets in a excel doc as json array
// Assumes sheets have header rows
const XLSX = require('xlsx');
const jsonfile = require('jsonfile');
const R = require('ramda');

const getWorkbook = () => XLSX.readFile('./data/test.xlsx');

const pickSheetsByName = (workbook) => R.pick(workbook.SheetNames, workbook.Sheets);

const getAllRowsFromAllSheets = R.pipe(
  R.pick(["Sheets", "SheetNames"]),
  pickSheetsByName,
  R.values,
  R.map(XLSX.utils.sheet_to_json),
  R.reduce(R.concat, [])
)

jsonfile.writeFileSync('./data/workbook.json', getAllRowsFromAllSheets(getWorkbook()));