87,910
社区成员
发帖
与我相关
我的任务
分享
const result = [];
/* 读取上传的表格*/
//首先监听input框的变动,选中一个新的文件会触发change事件
document.querySelector("#fileid").addEventListener("change", function () {
//获取到选中的文件
var file = document.querySelector("#fileid").files[0];
var type = file.name.split('.');
if (type[type.length - 1] !== 'xlsx' && type[type.length - 1] !== 'xls' && type[type.length - 1] !== 'csv') {
alert('只能选择excel文件导入');
return false;
}
const reader = new FileReader();
reader.readAsBinaryString(file);
reader.onload = (e) => {
const data = e.target.result;
const zzexcel = window.XLS.read(data, {
type: 'binary'
});
// const result = [];
console.log("长度"+JSON.stringify(zzexcel))
for (let i = 0; i < zzexcel.SheetNames.length; i++) {
//往表格插入ID号,因为表格的ID空的,查不出来,手动输入值
/* 生成随机ID*/
// time2 = (year+month+day+hour+minute+second);
// var suijiId = time2 + Math.ceil(Math.random(9999) * 10000) + 1000;//部门随机ID
// DepartID.push(suijiId) ;//
const newData = window.XLS.utils.sheet_to_json(zzexcel.Sheets[zzexcel.SheetNames[i]]) ;
result.push(...newData)
console.log("stt"+JSON.stringify(result))
}
biaogebumen=result;//
console.log('result', result)//打印出来的
}
});
for (let i = 0; i < zzexcel.SheetNames.length; i++) {
const newData = window.XLS.utils.sheet_to_json(zzexcel.Sheets[zzexcel.SheetNames[i]]);
/* 生成随机ID*/
time2 = (year+month+day+hour+minute+second);
var suijiId = time2 + Math.ceil(Math.random(9999) * 10000) + 1000;//部门随机ID
for(let i = 0; i < zzexcel.Sheets.length; i++){
if(!depart.DepartID){
depart.DepartID= suijiId;
}
}
result.push(...newData)
console.log("stt"+JSON.stringify(result))
}
biaogebumen=result;//为了下面变更
console.log('result', result)
}
console.log("长度"+JSON.stringify(zzexcel.Sheets));
打印如下(发现就行少了A2,A3这两个空的单元格,还有A1打印不出来):
{
"Sheet1": {
"!ref": "A1:B3",
"A1": {
"t": "s",
"v": "DepartID",
"r": "<t>DepartID</t>",
"h": "DepartID",
"w": "DepartID"
},
"B1": {
"t": "s",
"v": "DepartName",
"r": "<t>DepartName</t>",
"h": "DepartName",
"w": "DepartName"
},
"B2": {
"t": "s",
"v": "奥特曼部门",
"r": "<t>奥ç¹æ¼é¨é¨</t>",
"h": "奥特曼部门",
"w": "奥特曼部门"
},
"B3": {
"t": "s",
"v": "超人部门",
"r": "<t>è¶
人é¨é¨</t>",
"h": "超人部门",
"w": "超人部门"
}
},
"Sheet2": {},
"Sheet3": {}
}for(const depart in newData){
if(!depart.DepartID){
depart.DepartID='11111'
}
}