vue自定义表头内容excel表格导出

1、安装

npm install xlsx file-saver

2、使用

import * as XLSX from 'xlsx'
import { saveAs } from 'file-saver'const exportAccounts = (data) => {// 将对象数组转换为 worksheetconst worksheet = XLSX.utils.json_to_sheet(data)// 创建 workbook 并附加 sheetconst workbook = XLSX.utils.book_new()XLSX.utils.book_append_sheet(workbook, worksheet, '账户信息')// 生成 Excel 文件并下载const wbout = XLSX.write(workbook, { bookType: 'xlsx', type: 'array' })saveAs(new Blob([wbout], { type: 'application/octet-stream' }), '账户列表.xlsx')
}
const test = [{"email": "test@outlook.com","password": "test",
]exportAccounts(test)

3、效果