vue excelインポート

第1ステップnpm install-S file-saver xlsx npm install-D script-loader第2ステップ

ステップ3

export default {
name: 'app',
data(){
	return{
		excelData:[]
	}
},
methods:{
	ImpData(obj){
      let _this = this;
      this.file = event.currentTarget.files[0];  
      var rABS = false; //              
      var f = this.file;
      var reader = new FileReader();
      FileReader.prototype.readAsBinaryString = function(f) {
      var binary = "";
      var wb; //       
      var outdata;
      var reader = new FileReader();
      reader.onload = function(e) {
          var bytes = new Uint8Array(reader.result);
          var length = bytes.byteLength;
          for(var i = 0; i < length; i++) {
               binary += String.fromCharCode(bytes[i]);
          }
          var XLSX = require('xlsx');
          wb = XLSX.read(binary, {
             type: 'binary'
          });
          outdata = XLSX.utils.sheet_to_json(wb.Sheets[wb.SheetNames[0]]); 
          outdata.map(v => {
               let obj = {}
               obj.name= v.  
               obj.unit = v.  
               obj.use = v.  
               _this.excelData.push(obj)
          })
           _this.reload();
           }
           reader.readAsArrayBuffer(f);
          }
           reader.readAsBinaryString(f);
      },
      handleEdit(index, row){
          alert(row.name+','+row.unit +','+row.use );
      },
      handleDelete(row,rows){
          this.$confirm('           ,     ?', '  ', {
          confirmButtonText: '  ',
          cancelButtonText: '  ',
          type: 'warning'
        }).then(() => {
          for(var i=0 ;i {
          this.$message({
            type: 'info',
            message: '     '
          });
        });
      }

    }
 };