How to write to excel file using XLSX while keeping the same order

Question

Here is my code that writes to the sheet.

const handleClick = () => {
    var wb = XLSX.utils.book_new();
    var ws = XLSX.utils.json_to_sheet(arrayofobjects);
    XLSX.utils.book_append_sheet(wb, ws, 'Test');
    XLSX.writeFile(wb, 'file.xlsx');
};

let arrayofobjects = [
    {
        "00": 4,
        "01": 6,
        "10": 12,
        "11": 7,
    },
    {
        "00": 7,
        "01": 7,
        "10": 4,
        "11": 5,
    }
]

But I am getting output in another order in excel

This is what I am expecting

Can you show a sample of what you expect your output to look like? — W-B, Jun 27 '22 at 18:55
Objects in JavaScript are not guaranteed to be sorted in order by keys, either by their value or their insertion order. You can try this [Object.entries method](https://stackoverflow.com/a/37607084/636009) or [use a Map](https://stackoverflow.com/a/5525820/636009) instead, although I don't know if this XSLX API will accept those. — David Conrad, Jun 27 '22 at 19:10

score 1 · Accepted Answer · answered Jun 27 '22 at 22:26

What you are missing is a header array in the desired order.

for instance

// defined array of your headers
const header = ["00", "01", "10", "11"]

// create workbook as usual
const wb = XLSX.utils.book_new();

// here you pass an additional variable called header
const ws = XLSX.utils.json_to_sheet(
    arrayofobjects,
    {header:header}, //you can also use {header} but for simplicity's sake i left it as is
);

How to write to excel file using XLSX while keeping the same order

1 Answers1