• 导入


    importfxx(obj) {
    undefined
    let _this = this
    let inputDOM = this.$refs.inputer
    // 通过DOM取文件数据
    this.file = event.currentTarget.files[0]
    var rABS = false //是否将文件读取为二进制字符串
    var f = this.file
    var reader = new FileReader()
    FileReader.prototype.readAsBinaryString = function(f) {
    undefined
    var binary = ''
    var rABS = false //是否将文件读取为二进制字符串
    var pt = this
    var wb //读取完成的数据
    var outdata
    var reader = new FileReader()
    reader.onload = function(e) {
    undefined
    var bytes = new Uint8Array(reader.result)
    var length = bytes.byteLength
    for (var i = 0; i < length; i++) {
    undefined
    binary += String.fromCharCode(bytes[i])
    }
    var XLSX = require('xlsx')
    if (rABS) {
    undefined
    wb = XLSX.read(btoa(fixdata(binary)), {
    //手动转化
    type: 'base64'
    })
    } else {
    undefined
    wb = XLSX.read(binary, {
    undefined,
    type: 'binary'
    })
    }
    outdata = XLSX.utils.sheet_to_json(wb.Sheets[wb.SheetNames[0]]) //outdata就是你想要的东西
    this.da = [...outdata]
    let arr = []
    console.log(outdata)
    this.da.map(v => {
    undefined
    let obj = {}
    obj.id = v.id
    obj.status = v.status
    arr.push(obj)
    })
    let para = {
    undefined,
    withList: arr
    }
    _this.$message({
    undefined,
    message: '请耐心等待导入成功',
    type: 'success'
    })
    }
    reader.readAsArrayBuffer(f)
    }
    if (rABS) {
    undefined
    reader.readAsArrayBuffer(f)
    } else {
    undefined
    reader.readAsBinaryString(f)
    }
    },
  • 相关阅读:
    mysql 数据库备份
    半同步复制
    mysql在线热备
    mysqlxtrabackup备份
    MySQL备份与恢复
    Mysql语句类型
    MySQL的体系结构
    MySQL介绍及安装
    Shell-02-if
    Shell 脚本进阶,经典用法及其案例
  • 原文地址:https://www.cnblogs.com/zqlym/p/16115639.html
Copyright © 2020-2023  润新知