引入库文件
创建下载按钮
实现转换
var data = [
["Joa Doe", "[email protected]"],
["Job Doe", "[email protected]"],
["Joe Doe", "[email protected]"],
["Jon Doe", "[email protected]"],
["Joy Doe", "[email protected]"]
];
var workbook = XLSX.utils.book_new(),
worksheet = XLSX.utils.aoa_to_sheet(data);
workbook.SheetNames.push("First");
workbook.Sheets["First"] = worksheet;
res = XLSX.writeFile(workbook, "demo.xlsx");
下载文件
方式一： 库文件
window.saveAs(new Blob([wbout], { type: "application/octet-stream" }));
方式二： a 标签
onst link = document.createElement('a');
let blob = new Blob([res], {type: 'application/vnd.ms-excel'});
link.style.display = 'none';
link.href = URL.createObjectURL(blob);
link.download = "demo.xlsx";
document.body.appendChild(link);
link.click();
document.body.removeChild(link);