excel上传预览
这里会用到
npm i element-ui
npm i xlsx在vue的template中写上，排版和css看个人需求
<div> 选择文件
<input type="file" d="file_input" @change="importf(this)" accept=".csv, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, application/vnd.ms-excel" />
</div>
<div @click="fileBtn">上传到服务器</div>
<el-table class="listTable_ele" :data="listTable" stripe height="250" style="width:100%">
<el-table-column prop="name" label="员工姓名" width="180" align="center"></el-table-column>
<el-table-column prop="department" label="职务/部门" align="center"></el-table-column>
</el-table>vue的js中写上
export default {
data() {
return {
listTable: [] }
},
methods:{
// 上传预览
importf(obj) {
let that= this;
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就是你想要的东西 excel导入的数据
outdata = XLSX.utils.sheet_to_json(wb.Sheets[wb.SheetNames[0]]);
// excel 数据再处理
let arr = [];
// 这里需要注意名字一定要和excel的内容的文字对上
outdata.map(v => {
let obj = {};
obj.name = v.姓名;
obj.department = v.部门;
arr.push(obj);
});
// 放入到element的table中显示出来
that.listTable = arr;
};
reader.readAsArrayBuffer(f);
};
if (rABS) {
