首先引入依赖模块:
npm install xlsx --save
在需要解析excel的页面(vue文件)中引入依赖:
import XLSX from 'xlsx'
页面部分:
使用elementUI组件完成文件上传:
<!-- excel表格上传 -->
<el-upload
class="upload-demo"
drag
action="https://jsonplaceholder.typicode.com/posts/"
multiple
accept=".xlsx"
:on-exceed="exceed"
:limit="1"
:on-remove="remove"
:http-request="uploadFile"
>
<i class="el-icon-upload"></i>
<div class="el-upload__text">
将文件拖到此处,或
<em>点击上传</em>
</div>
<div class="el-upload__tip" slot="tip">1次只能上传1个xls文件,且不超过500k