先把excel转为json,参考: https://www.oh100.com/peixun/JSON/425371.html
let listOne = []
let listTwo = []
let listThree =[]
let father = ""
let father2 = ""
myData.data.forEach(element => {
if(element.一级类.length>0){
listOne.push(element.一级类)
father = element.一级类
}
if(element.二级类.length>0){
listTwo.push({label:element.二级类,father:father})
father2 = element.二级类
}
if(element.三级类.length>0){
listThree.push({label:element.三级类,father:father2})
}
});
let listOneObj = []
listOne.forEach(element => {
let obj = new Object()
obj.code = element
obj.label = element
obj.url = null
obj.type = null
obj.id = Math.floor((1 + Math.random()) * 0x1000000)
obj.parentId = null
listOneObj.push(obj)
});
let listTwoObj = []
listTwo.forEach(element => {
let fatherId = listOneObj.filter(item=>item.label == element.father)[0].id
let obj = new Object()
obj.code = element.label
obj.label = element.label
obj.url = null
obj.type = null
obj.id = Math.floor((1 + Math.random()) * 0x1000000)
obj.parentId = fatherId
listTwoObj.push(obj)
});
let listThreeObj = []
listThree.forEach(element => {
let fatherId = listTwoObj.filter(item=>item.label == element.father)[0].id
let obj = new Object()
obj.code = element.label
obj.label = element.label
obj.url = null
obj.type = null
obj.id = Math.floor((1 + Math.random()) * 0x1000000)
obj.parentId = fatherId
listThreeObj.push(obj)
});
let listAll = […listOneObj,…listThreeObj,…listTwoObj]