import XLSX from “xlsx”;
<input type="file" id="uploadFile" value="上传文件">
checkSheet() {const objFile = document.getElementById('uploadFile')if (objFile.value === '') {alert('请选择文件!')return}// 获取文件const files = objFile.filesconst _that = thisconst fileReader = new FileReader();fileReader.onload = function(ev) {console.log('ev: ', ev);const data = ev.target.result,workbook = XLSX.read(data, {type: 'binary'})let dataList = [];// 遍历每张表读取console.log('workbook: ', workbook);for (var sheet in workbook.Sheets) {if (workbook.Sheets.hasOwnProperty(sheet) && sheet === 'device') {dataList = dataList.concat(XLSX.utils.sheet_to_json(workbook.Sheets[sheet]));console.log('sheet: ', sheet);}}_that.analysisSheet(dataList)};fileReader.readAsBinaryString(files[0]);},analysisSheet(data) {console.log('data: ', data);},


