三级表格生成树状json

先把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]