安装 js-xlsx npm i js-xlsx 完成后引入
import * as XLSX from 'xlsx';
daochu(){
var filename = "write_num.xlsx";//文件名
var data = [
["id", "name", "price", "date"],// 第一行为导出标题,以后一次对应即可
[1, "makabaka", "¥7", "2022-3-11"],
[2, "搪玻璃波", "¥6", "2022-3-12"],
[3, "唔戏睇西", "¥8", "2022-3-13"],
];
var wb = XLSX.utils.book_new(), // 工作簿,即一个Excel文件
ws = XLSX.utils.aoa_to_sheet(data); // 工作表,即Excel内部的工作表
XLSX.utils.book_append_sheet(wb, ws, "SheetJS");
XLSX.writeFile(wb, filename);
},
运行结果