Vue+Element前端导入导出Excel

<el-upload
    class="upload-demo"
    :action="uploadUrl()"
    :limit="1"
    :data="uploadParams"
    accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, application/vnd.ms-excel"
    :on-exceed="handleExceed"
    :on-success="handleSuccess"
    :show-file-list="false"
>
    <el-button size="small" plain>导入</el-button>
    <div slot="tip" class="el-upload__tip">只能上传xlsx/xls文件</div>
</el-upload>

computed: {
   uploadParams() {
       let params = {
           importType: this.$route.params.wenjuanleixing
       };
       return params;
   }
}

// execl-上传相关
handleExceed(files, fileList) {
    this.$message.warning('只能上传一张execl表');
},
uploadUrl() {
    return '/sdkseaunion/execlImportApi/importInspect';
},
handleSuccess(file, fileList) {
   let { shipName } = file.data.biaotiItems;
   this.$router.push({
      path: `/questionDetail/add/${shipName}/${this.$route.params.wenjuanleixing}`
   });
}

 

https://segmentfault.com/a/1190000018993619

vue-element-admin版本

https://panjiachen.github.io/vue-element-admin-site/feature/component/excel.html#excel-export

 

https://blog.csdn.net/zhs961120/article/details/103182916?utm_medium=distribute.pc_relevant_t0.none-task-blog-BlogCommendFromMachineLearnPai2-1.nonecase&depth_1-utm_source=distribute.pc_relevant_t0.none-task-blog-BlogCommendFromMachineLearnPai2-1.nonecase