1、先安装依赖别的都好说:
cnpm install -S file-saver xlsx
cnpm install -D script-loader
2、还是老路子直接复制粘贴即可:
<el-button type="primary" @click="exportExcel(1,'')">导出</el-button>
//在methods定义方法
exportExcel(type) {
if (!type) {
console.log('导入')
} else {
let params = {
productName: this.ruleForm.productName,
drawStatus: this.ruleForm.drawStatus,
productCode: this.ruleForm.productCode,
currentPage: this.page.currentPage,
pageSize: this.page.pageSize
}
routerApi.exportList(params).then(res => {
console.log(res)
this.downloadFile(res, new Date().format("yyyyMMddhhmmss") + '卡券列表', 'xls')
})
console.log('导出')
}
},
downloadFile(obj, name, suffix) {
const url = window.URL.createObjectURL(new Blob([obj]))
console.log(new Blob([obj]), 'url')
const link = document.createElement('a')
link.style.display = 'none'
link.href = url
const fileName = name + '.' + suffix
link.setAttribute('download', fileName)
document.body.appendChild(link)
link.click()
document.body.removeChild(link)
},
大功告成 有多余代码自行删除