之前在工作有个需求是需要导入excel表
var obj = ev.target;
var isCSV;
var XLSX = require('xlsx');
var cptable = require('codepage/dist/cpexcel.full');
var wb;//读取完成的数据
var rABS = false; //是否将文件读取为二进制字符串
if (!obj.files) return;
var f = obj.files[0];
this.filename = f.name;
var reader = new FileReader();
reader.onload = (e) => {
var data = e.target.result;
wb = null;
if (isCSV) {
data = new Uint8Array(data);
let f = this.$isUTF8(data);
if (f) {
data = e.target.result;
} else {
var str = cptable.utils.decode(936, data);
wb = XLSX.read(str, { type: "string" });
}
}
if (!wb) {
wb = rABS|| isCSV ? XLSX.read(btoa(this.fixdata(data)), { type: 'base64' }) : XLSX.read(data, { type: 'binary' });
}
//wb.SheetNames[0]是获取Sheets中第一个Sheet的名字
//wb.Sheets[Sheet名]获取第一个Sheet的数据
this.$refs.pathClear.value ='';
this.$succmessages('请耐心等待导入成功');
_this.outdata = XLSX.utils.sheet_to_json(wb.Sheets[wb.SheetNames[0]]);//outdata~我想要的东西
console.log(_this.outdata);
};
isCSV = f.name.split(".").reverse()[0] === "csv";//判断是否是 CSV
if (rABS || isCSV) {
reader.readAsArrayBuffer(f);
} else {
reader.readAsBinaryString(f);
}