Documents -> Spreadsheet Array

script.js

/*
converts an array of objects into an array of row arrays,
suitable for use in e.g. a csv coversion (npm install csv-stringify)
includes the header row.
e.g.
objectArray = [{a: 1, b: 120}, {a: 2, c: 'horse'}]
toRows(objectArray) -> [ ['a', 'b', 'c'], [1, 120, undefined], [2, undefined, 'horse'] ]
*/

const toRows = objectArray => {
  const names = lodash
  .union.apply(lodash, objectArray.map(row => lodash.keys(row)))
  .sort();
  const rows = objectArray.map(obj => (
    names.map(name => obj[name])
  ));
  return [names, ...rows];
}