SOURCE

console 命令行工具 X clear

                    
>
console
document.getElementById('test-down').addEventListener('click',function(){
    //https://xlsx.nodejs.cn/docs/getting-started/examples/export
  /* flatten objects */
  const rows = [{"name":"George Washington","birthday":"1732-02-22"},
  {"name":"John Adams","birthday":"1735-10-19"}];
  console.log('rows',JSON.stringify(rows))
  /* generate worksheet and workbook */
  const worksheet = XLSX.utils.json_to_sheet(rows);
  const workbook = XLSX.utils.book_new();
  XLSX.utils.book_append_sheet(workbook, worksheet, "Dates");
  /* fix headers */
  XLSX.utils.sheet_add_aoa(worksheet, [["Name", "Birthday"]], { origin: "A1" });
  /* calculate column width */
  const max_width = rows.reduce((w, r) => Math.max(w, r.name.length), 10);
  worksheet["!cols"] = [ { wch: max_width } ];
  /* create an XLSX file and try to save to Presidents.xlsx */
  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>

本项目引用的自定义外部资源