首先下载xlsx插件
npm i xlsx
其次页面引入
import * as XLSX from 'xlsx/xlsx.mjs'
页面部分：搭配element-ui的下载组件
<el-upload actionclass="importExcel"accept=".xlsx, .xls":auto-upload="false":show-file-list="false":on-change="selectFileChange"><el-button type="text" size="medium">导入</el-button></el-upload>
实现函数：
methods: {// 导入excel并解析readFile (file) {//文件读取return new Promise(resolve => {let reader = new FileReader();reader.readAsBinaryString(file);//以二进制的方式读取reader.onload = ev => {resolve(ev.target.result);}})},async selectFileChange (ev) {let file = ev.raw;if (file.name.indexOf('xlsx') == -1 || file.name.indexOf('xls') == -1) {this.$message({message: '请选择xlsx、xls格式文件',type: 'warning'});return}if (!file) {this.$message({message: '文件导入失败',type: 'warning'});return;} else {let data = await this.readFile(file);let workbook = XLSX.read(data, {type: "binary" });//解析二进制格式数据// console.log('二进制数据的解析:')// console.log(workbook)let worksheet = workbook.Sheets[workbook.SheetNames[0]];//获取第一个Sheetlet result = XLSX.utils.sheet_to_json(worksheet);//json数据格式console.log(result)}},}
