如何在保留相同订单的同时使用XLSX写入Excel文件

Question

这是我写给表格的代码。

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,
    }
]

但我在Excel

这就是我期望的

Answer 1

您缺少的是按期望顺序的标头数组。

例如

// 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
);