vue项目中将表格导出为Excel
- 定义点击事件
<el-form-item>
<el-button type="primary" @click="onSubmit" size="small" class="btn"
>查询</el-button
>
<el-button type="primary" @click="Export" size="small" class="btn"
>导出</el-button
>
</el-form-item>
- 在methods中编辑以下代码:
methods:{
Export(){
if(this.list.length <= 0){
this.$message({
showClose: true,
message: '暂无可导出数据!',
type: 'warning'
});
return;
}
// 初始化
var workbook = XLSX.utils.book_new();
// 数据
var ws1 = XLSX.utils.table_to_sheet(document.getElementById("table"));
// 这是 Sheet
XLSX.utils.book_append_sheet(workbook, ws1, "Sheet1");
XLSX.writeFile(workbook, "输出文件名称.xlsx");
},
}