前端导入表格

最新推荐文章于 2024-03-09 11:00:56 发布

曾十一一一

最新推荐文章于 2024-03-09 11:00:56 发布

阅读量147

点赞数 1

文章标签：前端 elementui vue.js typescript

本文链接：https://blog.csdn.net/qq_45733762/article/details/126054806

版权

<el-upload
            class="upload-demo"
            action=""
            :on-change="handleChange"
            :on-exceed="handleExceed"
            :on-remove="handleRemove"
            :limit="1"
            accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet,application/vnd.ms-excel"
            :auto-upload="false">
            <el-button size="small" type="primary">点击上传</el-button>
            <div slot="tip" class="el-upload__tip">只 能 上 传 xlsx / xls 文 件</div>
          </el-upload>

 private handleChange(file: any){
      this.fileTemp = file.raw;
      if(this.fileTemp){
          if((this.fileTemp.type == 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet') || (this.fileTemp.type == 'application/vnd.ms-excel')){
              this.importfxx(this.fileTemp)
          } else {
              this.$message({
                  type:'warning',
                  message:'附件格式错误，请删除后重新上传！'
              })
          }
      } else {
          this.$message({
              type:'warning',
              message:'请上传附件！'
          })
      }
    }

    private importfxx(obj: any) {
    let _this = this;
    // 通过DOM取文件数据
    this.file = obj
    var rABS = false; //是否将文件读取为二进制字符串
    var f = this.file;
    var reader = new FileReader();
    FileReader.prototype.readAsBinaryString = function(f) {
        var binary = "";
        var rABS = false; //是否将文件读取为二进制字符串
        var pt = this;
        var wb; //读取完成的数据
        var outdata;
        var reader = new FileReader();
        /*
        在读取后，触发的事件，并获取读取文件的地址
        */
        reader.onload = function(e) {
        //返回的结果为reader.result是类型化数组
        var bytes = new Uint8Array(reader.result);
        var length = bytes.byteLength;
        for(var i = 0; i < length; i++) {
            binary += String.fromCharCode(bytes[i]); //将 Unicode 编码转为一个字符:
        }

        var XLSX = require('xlsx');
        if(rABS) {
            wb = XLSX.read(btoa(fixdata(binary)), { //手动转化
                type: 'base64'
            });
        } else {
            wb = XLSX.read(binary, {
                type: 'binary'
            });
        }
        outdata = XLSX.utils.sheet_to_json(wb.Sheets[wb.SheetNames[0]]);//outdata就是你想要的东西
            // this.da = [...outdata]
            // let arr = []
            // this.da.map(v => {
            //     let obj = {}
            //     obj.name = v['姓名']
            //     obj.phone = v['电话']
            //     obj.addres = v['地址']
            //     arr.push(obj)
            // })
            // return arr
            console.log(outdata);
            
        }
        //开始读取指定的Blob中的内容，一旦完成，result属性中保存的将是被读取文件的
        reader.readAsArrayBuffer(f);
    }

    if(rABS) {
        reader.readAsArrayBuffer(f);
    } else {
        reader.readAsBinaryString(f);
    }
  }