1.导出excel功能
![在这里插入图片描述](https://img-blog.csdnimg.cn/ddb5874fe0054b67a979ee04a937aff9.png)
- 首先 npm 安装 js-table2execl
npm install js-table2execl
- 在页面中引入,(也可以全局引入)
import table2excel from 'js-table2excel';
- 在代码中使用
<el-col :span="1.5">
<el-button type="success" plain icon="el-icon-upload2" size="mini" :disabled="multiple" @click="handleExport">导出文件</el-button>
</el-col>
handleExport() {
var tableData = this.useractivitymessageList;
var dataList = [];
tableData.forEach(item => {
const spliceLength = item.facePicture.lastIndexOf("/");
item.imageName = item.facePicture.slice(spliceLength + 1);
dataList.push({
userName: item.userName,
userId: item.userId,
phoneNumber: item.phoneNumber,
idCardno: item.idCardno,
imageName: item.imageName,
company: item.company,
facePicture: item