vue+element-ui,实现Excel导入导出,参考:
https://www.jianshu.com/p/02d615d60949
做excel表格导入时,处理导入数据
//拿到的数据:
let dataArray=[{'卡号':'123','手机号':'18374174400'}];
//想要的数据:
let newObjArray=[{'card':'123','mobile':'18374174400'}];
数据处理方法:
//处理导入的数据
let dataArray=[{'卡号':'123','手机号':'18374174400'}];
initDate(dataArray) {
let newObjArray = [];
let keyMap = { '卡号': 'card', '手机号': 'mobile' }
dataArray.forEach(item => {
var objs = Object.keys(item).reduce((newData, key) => {
let newKey = keyMap[key] || key;
newData[newKey] = item[key];
return newData;
}, {})
newObjArray.push(objs);
})
console.log("newObjArray", newObjArray)
}