要做纯前段的导入导出,搜索了好多地方才算把功能完整写出来了 ,这里整理一下,以备下次使用。
1.首先需要npm安装
npm install -S file-saver xlsx(这里其实安装了2个依赖)
npm install -D script-loader
2.在src目录下新建excel文件夹,然后引入Blob.js和Expor2Excel.js
百度云盘 可获取到Blob.js和Expor2Excel.js
链接: https://pan.baidu.com/s/1z0sieEiY5wf4tpY-845k5A 提取码: b38k
//Expor2Excel.js中,路径要和自己实际文件路径一致
require('script-loader!file-saver');
require('./Blob.js'); //根据自己项目的实际路径
require('script-loader!xlsx/dist/xlsx.core.min');
3.导出excel功能
<el-button size="mini" @click="handleExportExcel">下载excel</el-button>
export default {
method(){
handleExportExcel() {
let that = this
// 数据请求延迟
require.ensure([], () => {
const {
export_json_to_excel
} = require('../../excel/Export2Excel') //根据自己的实际路径填写
const tHeader = ['姓名','性别']
const filterVal = ['name','sex']
const list = []
const data = that.formatJson(filterVal, list)
export_json_to_excel(tHeader, data, '人员列表')
})
},
formatJson(filterVal, jsonData) {
return jsonData.map(v => filterVal.map(j => v[j]))
},
}
}
4.导入功能(结合element的上传功能做的)
<el-upload class="upload-demo"
action=""
:on-change="handleChange"
:show-file-list="false"
accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet,application/vnd.ms-excel"
:auto-upload="false" >
<el-button size="mini" icon="el-icon-plus" type="primary">批量导入</el-button>
</el-upload>
/** 导入按钮操作 **/
handleChange(file, fileList) { //excel文件改变
this.fileTemp = file.raw
if (this.fileTemp) {
if ((this.fileTemp.type == 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet') || (this.fileTemp
.type == 'application/vnd.ms-excel')) {
this.importExcel(this.fileTemp)
} else {
this.$message({
type: 'warning',
message: '附件格式错误,请删除后重新上传!'
})
}
} else {
this.$message({
type: 'warning',
message: '请上传附件!'
})
}
},
importExcel(obj) {
let _this = this;
// 通过DOM取文件数据
this.file = obj
var rABS = false; //是否将文件读取为二进制字符串
var f = this.file;
var reader = new FileReader();
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就是你想要的东西
this.da = [...outdata]
//这里 处理导入的excel数据
let arr = []
this.da.map(v => {
let name= v['姓名']
arr.push(name=)
})
//以下下 这里去处理导入的excel数据怎么存储到数据库中
//.....
//.....
return arr
}
reader.readAsArrayBuffer(f);
}
if (rABS) {
reader.readAsArrayBuffer(f);
} else {
reader.readAsBinaryString(f);
}
},