SheetJS Record serializer

sheetjs-serialize-record.js

const XLSX = require('xlsx');

const data = {
    key1: 'foo',
    key2: {
        bar: 'baz',
        test: {
            omg: true,
        },
    },
};

const isObject = (obj) => {
    if (typeof obj === 'object' && obj !== null) {
        return Object.getPrototypeOf(obj) === Object.prototype;
    } else {
        return false;
    }
};

const objToAoa = (obj) => {
    const process = (obj, target = []) => {
        Object.entries(obj).forEach(([key, value]) => {
            if (isObject(value) || Array.isArray(value)) {
                const result = process(value);
                target.push([key]);
                result.forEach((row) => {
                    target.push(["", ...row]);
                });
            } else {
                target.push([key, String(value)]);
            }
        });
        return target;
    };
    return process(obj);
};

const worksheet = XLSX.utils.aoa_to_sheet(objToAoa(data))

const workbook = XLSX.utils.book_new();
XLSX.utils.book_append_sheet(workbook, worksheet, "Records");

XLSX.writeFile(workbook, "Records.xlsx");