vue读取excel表格数据_vue 2.x 导入excel获取Excel数据

安装:

yarn add file-saver

yarn add xlsx

yarn add script-loader --dev

或者npm安装:

npm install -S file-saver xlsx(这里其实安装了2个依赖)

npm install-D script-loader

在src下创建一个文件夹，包含两个文件：

然后再main.js中导入这两个文件;

code:

HTML:

js:

export default {

data() {

return {};

},

methods: {

importfxx(obj) {

let _this = this;

console.log("xxxxxxxxxxxxxxxxxxxxxxxxxxx1");

let inputDOM = this.$refs.inputer;

// 通过DOM取文件数据

this.file = event.currentTarget.files[0];

var rABS = false; //是否将文件读取为二进制字符串

var f = this.file;

var reader = new FileReader();

//if (!FileReader.prototype.readAsBinaryString) {

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) {

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");

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就是你想要的东西

console.log(outdata)

};

reader.readAsArrayBuffer(f);

};

if (rABS) {

reader.readAsArrayBuffer(f);

} else {

reader.readAsBinaryString(f);

}

}

}

};