数据导出到excel
文章摘自https://blog.csdn.net/hhzzcc_/article/details/80419396
截图
源代码
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Vue 测试实例 - 菜鸟教程(runoob.com)</title>
<script src="https://cdn.bootcss.com/vue/2.4.2/vue.min.js"></script>
<style>
button {
width:80px;
height:32px;
font-size:15px;
color:#fff;
background:#64bd63;
border:none;
border-radius: 5px;
outline:none;
cursor:pointer;
}
</style>
</head>
<body>
<div id="app">
<button @click='tableToExcel()' >导出</button>
</div>
<script>
new Vue({
el: '#app',
data: {
tableData:[{name:'明明',phone: 12345678910,address:'中国'},
{name:'明明',phone: 12345678910,address:'中国'},
{name:'明明',phone: 12345678910,address:'中国'},
{name:'明明',phone: 12345678910,address:'中国'},
{name:'明明',phone: 12345678910,address:'中国'}]
},
methods: {
tableToExcel() {
let title = `姓名,电话,地址\n`;
for(let i = 0 ; i < this.tableData.length ; i++ ){
for(let item in this.tableData[i]){
title+=`${this.tableData[i][item] + '\t'},`;
}
title+='\n';
}
let uri = 'data:text/xls;charset=utf-8,\ufeff' + encodeURIComponent(title);
var link = document.createElement("a");
link.href = uri;
link.download = "json数据表.xls";
document.body.appendChild(link);
link.click();
document.body.removeChild(link);
}
}
})
</script>
</body>
</html>