js实现特定excel导入文件拼装数据

<template><div class="content"><aui-file-upload :action="action" :before-upload="beforeAvatarUpload" :file-list="fileList" @change="handleChange" style="margin-left:10px;"><aui-button type="primary">点击上传</aui-button></aui-file-upload></div>
</template><script>
import { Button, Layout, Row, Col, Select, Option, FileUpload } from "@aurora/vue";
import XLSX from 'xlsx'
export default {name: "CommonFilters",components: {AuiButton: Button,AuiLayout: Layout,AuiRow: Row,AuiCol: Col,AuiSelect: Select,AuiOption: Option,AuiFileUpload: FileUpload,},data() {return {gl:{'1':'国家整体信息是否封国封城','2':'国家整体信息是否限制人员外出（武汉模式）','3':'国家整体信息是否停飞停航','4':'国家整体信息境内物流是否通畅','5':'国家整体信息竞争对手情况（疫情的应对措施、防疫物资是否充足，对手动态等）','6':'国家整体信息和银行对接的业务是否受影响','7':'国家整体信息是否有外汇、汇困、信用、融资风险','8':'国家整体信息备注','9':'客户交流与关怀分类','10':'客户交流与关怀客户是否已启动远程办公(Home Office)','11':'客户交流与关怀是否允许供应商办公室拜访','12':'客户交流与关怀是否部署线上视频系统（Welink/电子白板等）','13':'客户交流与关怀是否提供口罩等物资','14':'客户交流与关怀是否已经输出疫情期间客户关怀应对预案和分客户群成立项目组','15':'客户交流与关怀是否成立疫情期间网络保障项目组，项目组成员保持7*24小时待命，项目组成员名单已提供给客户，以便于随时联系。','16':'客户交流与关怀是否系统部完成与CXO汇报疫情期间华为网络保障预案，并定期推送网络保障、供应、工程交付最新进展，提升客户感知','17':'客户交流与关怀备注','18':'数字化营销是否已建疫情专区','20':'数字化营销疫情下专题交流归档数','21':'数字化营销系统部CC3人均访问专区次数','22':'数字化营销系统部提升建议','23':'PO获取是否有影响','24':'PO获取应对措施','25':'PO获取是否电子签','26':'PO获取当前影响','27':'PO获取应对预案','28':'PO获取电子件/B2B','29':'PO获取当前影响','30':'PO获取应对预案','31':'无接触交付验收客户是否封网','32':'无接触交付验收设备制造（是否影响，如果是，需要备注影响什么内容）','33':'无接触交付验收运输（是否影响，如果是，需要备注影响什么内容）','34':'无接触交付验收清关（是否影响，如果是，需要备注影响什么内容）','35':'无接触交付验收出入库（是否影响，如果是，需要备注影响什么内容）','36':'无接触交付验收计划协同（客户沟通方式：是ISDP系统、邮件还是面对面）','37':'无接触交付验收勘测设计审批（eSurvey审批、是邮件审批）','38':'无接触交付验收安装（分包商是否可以进场施工：正常施工、不能施工、时间受限施工（开始—结束时间）、申请到通信许可后可施工）','39':'无接触交付验收质量审批（是否拉远）','40':'无接触交付验收是否远程验收','41':'无接触交付验收POD/PAC报告签署方式：（当面签署还是邮件审批还是什么方式？？）；是否已经实现B2B对接','42':'无接触交付验收电子件/B2B','43':'无接触交付验收当前影响','44':'无接触交付验收应对预案','45':'无接触交付验收电子件/B2B/纸面','46':'无接触交付验收当前影响','47':'无接触交付验收影响金额','48':'无接触交付验收应对预案','49':'无接触交付验收应急故障处理（是否影响，如果是，需要备注影响什么内容）','50':'无接触交付验收主动预防性维护（是否影响，如果是，需要备注影响什么内容）','51':'无接触交付验收备件供应（是否影响，如果是，需要备注影响什么内容）','52':'交易风险是否有影响','53':'交易风险应对预案','54':'交易风险是否有影响','55':'交易风险应对预案','56':'交易风险是否有影响','57':'交易风险应对预案','58':'交易风险当前影响','59':'交易风险影响金额','60':'交易风险应对预案','61':'交易风险当前影响','62':'交易风险影响金额','63':'交易风险应对预案','64':'交易风险当前影响','65':'交易风险影响金额','66':'交易风险应对预案','67':'交易风险断点管理'},action: '',imageUrl: '',fileList: [],};},methods: {// 读excelhandleChange(res) {let abc = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'var files = res.rawvar reader = new FileReader();let start,endreader.onloadend = async ()=> {start = new Date()let submitData = []let workbook = XLSX.read(reader.result, {bookType: 'xlsx', bookSST: false, type: 'binary'})let x = 10,y = 6// for(y<workbook)let orm = {last_update_by:this.userAccount}let Sheets = workbook.SheetNames// sheets名字let keyFirst = Sheets[0]// 拿到的值let excelData = workbook.Sheets[keyFirst]let lenY = (excelData['!ref'].split(':')[1]).replace(/[^0-9]/ig,"")let x_top = (excelData['!ref'].split(':')[1]).replace(/[^A-Z]/ig,"")let lenX = 0if(x_top.length==1){lenX = abc.indexOf(x_top)+1}else{for(let j=0;j<x_top.length;j++){if(j<x_top.length-1){lenX += (abc.indexOf(x_top[j])+1)*26}else{lenX+=abc.indexOf(x_top[j])+1}// console.log(abc.indexOf(x_top[j])+1)}}// console.log(excelData,lenY,lenX)// Y轴do{// console.log(y)// X轴let list_first = nullfor(;x<lenX;x++){let key = null,qian = nullif(x<26){key = abc[x]+yqian = abc[x]}else{let ho = x%26let qi = parseInt(x/26)key = abc[qi-1]+abc[ho]+yqian = abc[qi-1]+abc[ho]}if(excelData[qian+'1']!=undefined){list_first = excelData[qian+'1']}let obj = {}obj['region_cn'] = excelData['B'+y]?.v || ''obj['region_en'] = excelData['B'+y]?.v || ''obj['region_code'] = 1obj['repoffice_cn'] = excelData['D'+y]?.v || ''obj['repoffice_en'] = excelData['D'+y]?.v || ''obj['repoffice_code'] = excelData['C'+y]?.v || ''obj['country_cn'] = excelData['F'+y]?.v || ''obj['country_en'] = excelData['F'+y]?.v || ''obj['country_code'] = excelData['E'+y]?.v || ''obj['dept_cn'] = excelData['H'+y]?.v || ''obj['dept_en'] = excelData['H'+y]?.v || ''obj['dept_code'] = excelData['G'+y]?.v || ''obj['account_cn'] = excelData['J'+y]?.v || ''obj['account_en'] = excelData['J'+y]?.v || ''obj['account_code'] = excelData['I'+y]?.v || ''let gl_key = Object.keys(this.gl)let gl_value = Object.values(this.gl)// console.log(list_first?.v,excelData[qian+'3']?.v,qian)let strs = (list_first?.v+excelData[qian+'3']?.v).replace(/\ +/g,"").replace(/[\r\n]/g,"");let gl_idx = gl_value.findIndex(e=>e.replace(/\ +/g,"")==strs)obj['column_id'] = gl_key[gl_idx]obj['column_value'] = excelData[key]?.v || undefinedobj['last_update_by'] = this.$service.base.getUserInfoSync().employeeNumber;await this.submitExcel(obj)console.log(`上传完成坐标：x:${x},y:${y}`)submitData.push(obj)}x=10y++}while(y<parseInt(lenY))console.log(submitData)end = new Date()let second = ((end-start) % (1000 * 60)) / 1000;let minutes = parseInt(((end-start) % (1000 * 60 * 60)) / (1000 * 60));console.log(`用时${minutes}分${second}秒`)this.sendSearch()}// reader.readAsText(files);reader.readAsBinaryString(files)},async submitExcel(param){// await new Promise(resolve => setTimeout(resolve, 1000));let params = Object.assign({},param)let value = Object.values(params)let key = Object.keys(params)key.map((obj,idx)=>{params[obj] = unescape(encodeURIComponent(value[idx]));})params = JSON.stringify(params)params = escape(params).replace(/\:/g, '%3A')let result = await httpAjax.callDisApiByServiceCode('xxx', params)if(result=='ok'){// console.log(result,'添加成功')}else{console.log(param)Modal.message({ message:`类型：${this.gl[param.column_id]}添加失败`, status: 'error' })}},//  禁止提交beforeAvatarUpload(file) {return false},},
};
</script>
[添加链接描述](https://download.csdn.net/download/qq_26934957/12461673)