1、安装

npm install -S file-saver xlsx

npm install -D script-loader

npm install xlsx

2、使用

import * as XLSX from 'xlsx'

upExcel(e){

var file = e.target.files[0];

var reader = new FileReader();

reader.onload = function() {

try {

var bytes = new Uint8Array(reader.result);

var length = bytes.byteLength;

var binary = "";

for (var i = 0; i < length; i++) {

binary += String.fromCharCode(bytes[i]);

}

//此处引入，用于解析excel

// var XLSX = new xlsx();

var wb = XLSX.read(binary, {

type: "binary"

});

console.log(wb)

// var outdata = XLSX.utils.sheet_to_json(wb.Sheets[wb.SheetNames[0]]);

// //outdata就是读取的数据（不包含标题行即表头，表头会作为对象的下标）

// //此处可对数据进行处理

// let arr = [];

// outdata.map(v => {

// console.log(v)

// let obj = {}

// // obj.code = v['Code']

// // obj.name = v['Name']

// // obj.pro = v['province']

// // obj.cit = v['city']

// // obj.dis = v['district']

// arr.push(obj)

// });

} catch (error) {

console.log(error)

}

};

reader.readAsArrayBuffer(file);

}