console
document.getElementById('test-down').addEventListener('click',function(){
const rows = [{"name":"George Washington","birthday":"1732-02-22"},
{"name":"John Adams","birthday":"1735-10-19"}];
console.log('rows',JSON.stringify(rows))
const worksheet = XLSX.utils.json_to_sheet(rows);
const workbook = XLSX.utils.book_new();
XLSX.utils.book_append_sheet(workbook, worksheet, "Dates");
XLSX.utils.sheet_add_aoa(worksheet, [["Name", "Birthday"]], { origin: "A1" });
const max_width = rows.reduce((w, r) => Math.max(w, r.name.length), 10);
worksheet["!cols"] = [ { wch: max_width } ];
XLSX.writeFile(workbook, "Presidents.xlsx", { compression: true });
console.log('worksheet',worksheet)
console.log('workbook',workbook)
})
<button type="button" id="test-down">测试导出</button>
<div style="color:red">jsrun在线编辑,sheetjs无法下载xlsx 原因未知</div>