npm install xlsx -S
import XLSX from 'xlsx'
let data = [{ id: 1, name: 'john', nick: 'test' }, { id: 2, name: 'toms', nick: 'test1' }]
let tableData = [
['ID', '账号', '昵称', '中奖人姓名', '中奖人单位', '中奖人手机号', '运营商', '邮箱', '详细地址', '奖项', '奖品']
]
let keyArr = ['userId', 'loginName', 'nickName', 'userName', 'school', 'telNum', 'operator', 'email', 'address', 'levelName', 'detaile']
listData.forEach(item => {
tableData.push(keyArr.map(key => {
return item[key] || ''
})
)
})
const ws = XLSX.utils.aoa_to_sheet(tableData)
const wb = XLSX.utils.book_new()
XLSX.utils.book_append_sheet(wb, ws, 'SheetJS')
XLSX.writeFile(wb, '名单.xlsx')