const data = [ { "DEPARTID": "1", "DEPART": "社领导", "UPDEPARTMENTID": "0", "CHILDREN": [ ] }, { "DEPARTID": "2", "DEPART": "总编辑", "UPDEPARTMENTID": "0", "CHILDREN": [ ] }, { "DEPARTID": "10", "DEPART": "总编办公室", "UPDEPARTMENTID": "0", "CHILDREN": [] }, { "DEPARTID": "3", "DEPART": "综合管理部", "UPDEPARTMENTID": "0" }, { "DEPARTID": "5", "DEPART": "人力资源部", "UPDEPARTMENTID": "0" }, { "DEPARTID": "7", "DEPART": "印务与资源管理部", "UPDEPARTMENTID": "0" }, { "DEPARTID": "8", "DEPART": "计划财务处", "UPDEPARTMENTID": "0" }, { "DEPARTID": "9", "DEPART": "后勤保障部", "UPDEPARTMENTID": "0" }, { "DEPARTID": "12", "DEPART": "销售中心", "UPDEPARTMENTID": "0", "CHILDREN": [ { "DEPARTID": "24", "DEPART": "营销中心-储运部", "UPDEPARTMENTID": "12" }, { "DEPARTID": "25", "DEPART": "铁路延伸市场图书营销部", "UPDEPARTMENTID": "12" }, { "DEPARTID": "26", "DEPART": "(停用)业务二部", "UPDEPARTMENTID": "12" }, { "DEPARTID": "27", "DEPART": "(停用)直销部", "UPDEPARTMENTID": "12" }, { "DEPARTID": "28", "DEPART": "营销中心-市场部", "UPDEPARTMENTID": "12" }, { "DEPARTID": "29", "DEPART": "门市（停用）", "UPDEPARTMENTID": "12" }, { "DEPARTID": "30", "DEPART": "营销中心-教材图书营销部", "UPDEPARTMENTID": "12" }, { "DEPARTID": "38", "DEPART": "铁路图书营销部", "UPDEPARTMENTID": "12" }, { "DEPARTID": "39", "DEPART": "发行分部", "UPDEPARTMENTID": "12" }, { "DEPARTID": "41", "DEPART": "营销中心-社会大众图书营销部", "UPDEPARTMENTID": "12" } ] }, { "DEPARTID": "31", "DEPART": "铁道书店", "UPDEPARTMENTID": "0" }, { "DEPARTID": "83", "DEPART": "企法与审计部", "UPDEPARTMENTID": "0" }, { "DEPARTID": "13", "DEPART": "编务与质量中心", "UPDEPARTMENTID": "0" }, { "DEPARTID": "17", "DEPART": "铁路建设与城轨出版中心", "UPDEPARTMENTID": "0", "CHILDREN": [ { "DEPARTID": "16", "DEPART": "建设_工务工程与房建", "UPDEPARTMENTID": "17" }, { "DEPARTID": "42", "DEPART": "建设_信号与控制", "UPDEPARTMENTID": "17" }, { "DEPARTID": "66", "DEPART": "建设_铁路工程", "UPDEPARTMENTID": "17" }, { "DEPARTID": "67", "DEPART": "建设_城轨交通", "UPDEPARTMENTID": "17" }, { "DEPARTID": "68", "DEPART": "建设_建筑工程", "UPDEPARTMENTID": "17" }, { "DEPARTID": "74", "DEPART": "建设_铁路供电", "UPDEPARTMENTID": "17" }, { "DEPARTID": "75", "DEPART": "建设_通信与信息", "UPDEPARTMENTID": "17" } ] }, { "DEPARTID": "19", "DEPART": "大众出版中心", "UPDEPARTMENTID": "0", "CHILDREN": [ { "DEPARTID": "35", "DEPART": "大众_科普", "UPDEPARTMENTID": "19" }, { "DEPARTID": "49", "DEPART": "大众_市场", "UPDEPARTMENTID": "19" }, { "DEPARTID": "50", "DEPART": "大众_信息技术", "UPDEPARTMENTID": "19" }, { "DEPARTID": "58", "DEPART": "大众_文化", "UPDEPARTMENTID": "19" }, { "DEPARTID": "59", "DEPART": "大众_人文_停用", "UPDEPARTMENTID": "19" }, { "DEPARTID": "61", "DEPART": "大众_期刊", "UPDEPARTMENTID": "19" }, { "DEPARTID": "64", "DEPART": "大众_期刊_铁路文艺（停用）", "UPDEPARTMENTID": "19" }, { "DEPARTID": "76", "DEPART": "大众_经济", "UPDEPARTMENTID": "19" }, { "DEPARTID": "77", "DEPART": "大众_管理", "UPDEPARTMENTID": "19" } ] }, { "DEPARTID": "20", "DEPART": "音像电子与数字出版中心", "UPDEPARTMENTID": "0", "CHILDREN": [ { "DEPARTID": "21", "DEPART": "音像_音像电子", "UPDEPARTMENTID": "20" }, { "DEPARTID": "37", "DEPART": "音像_融合出版", "UPDEPARTMENTID": "20" }, { "DEPARTID": "78", "DEPART": "音像_信息技术", "UPDEPARTMENTID": "20" }, { "DEPARTID": "79", "DEPART": "音像_信息管理", "UPDEPARTMENTID": "20" }, { "DEPARTID": "82", "DEPART": "音像_课程研发", "UPDEPARTMENTID": "20" }, { "DEPARTID": "86", "DEPART": "音像-融媒体工作室", "UPDEPARTMENTID": "20" } ] }, { "DEPARTID": "23", "DEPART": "装帧设计中心", "UPDEPARTMENTID": "0" }, { "DEPARTID": "32", "DEPART": "教材出版中心", "UPDEPARTMENTID": "0", "CHILDREN": [ { "DEPARTID": "52", "DEPART": "教材_高等教育", "UPDEPARTMENTID": "32" }, { "DEPARTID": "53", "DEPART": "教材_职业教育", "UPDEPARTMENTID": "32" }, { "DEPARTID": "54", "DEPART": "教材_城市轨道", "UPDEPARTMENTID": "32" }, { "DEPARTID": "57", "DEPART": "教材_基础（停用）", "UPDEPARTMENTID": "32" }, { "DEPARTID": "85", "DEPART": "教材_机电教材", "UPDEPARTMENTID": "32" }, { "DEPARTID": "87", "DEPART": "教材_推广一部", "UPDEPARTMENTID": "32" }, { "DEPARTID": "88", "DEPART": "教材_推广二部", "UPDEPARTMENTID": "32" } ] }, { "DEPARTID": "34", "DEPART": "其他", "UPDEPARTMENTID": "0" }, { "DEPARTID": "43", "DEPART": "铁路文化与综合出版中心", "UPDEPARTMENTID": "0", "CHILDREN": [ { "DEPARTID": "15", "DEPART": "文化_机车与标准化", "UPDEPARTMENTID": "43" }, { "DEPARTID": "22", "DEPART": "文化_综合管理", "UPDEPARTMENTID": "43" }, { "DEPARTID": "48", "DEPART": "文化_企业文化", "UPDEPARTMENTID": "43" }, { "DEPARTID": "73", "DEPART": "文化_动车与车辆", "UPDEPARTMENTID": "43" }, { "DEPARTID": "89", "DEPART": "文化_宣传与教育", "UPDEPARTMENTID": "43" }, { "DEPARTID": "90", "DEPART": "文化_物流与经济", "UPDEPARTMENTID": "43" } ] }, { "DEPARTID": "46", "DEPART": "铁路运营出版中心", "UPDEPARTMENTID": "0", "CHILDREN": [ { "DEPARTID": "14", "DEPART": "铁路运营_运输与安全", "UPDEPARTMENTID": "46" }, { "DEPARTID": "44", "DEPART": "铁路运营_科技期刊（停用）", "UPDEPARTMENTID": "46" }, { "DEPARTID": "56", "DEPART": "铁路运营_铁路教材", "UPDEPARTMENTID": "46" }, { "DEPARTID": "71", "DEPART": "铁路运营_货运与物流", "UPDEPARTMENTID": "46" }, { "DEPARTID": "72", "DEPART": "铁路运营_客运与经管", "UPDEPARTMENTID": "46" } ] }, { "DEPARTID": "63", "DEPART": "数字出版中心（停用）", "UPDEPARTMENTID": "0", "CHILDREN": [ { "DEPARTID": "33", "DEPART": "数字_马术（停用）", "UPDEPARTMENTID": "63" }, { "DEPARTID": "65", "DEPART": "数字_资源建设与产品研发（停用）", "UPDEPARTMENTID": "63" } ] }, { "DEPARTID": "69", "DEPART": "北京时刻文化传媒中心（停用）", "UPDEPARTMENTID": "0" }, { "DEPARTID": "80", "DEPART": "经营策划中心", "UPDEPARTMENTID": "0", "CHILDREN": [ { "DEPARTID": "45", "DEPART": "经营策划_地图", "UPDEPARTMENTID": "80" }, { "DEPARTID": "81", "DEPART": "经营策划_综合策划", "UPDEPARTMENTID": "80" } ] }, { "DEPARTID": "84", "DEPART": "党群工作部", "UPDEPARTMENTID": "0" }, { "DEPARTID": "70", "DEPART": "退休离职", "UPDEPARTMENTID": "0" } ]; import xlsx from "node-xlsx"; import * as fs from 'fs'; const result = [['DEPARTID','DEPART','UPDEPARTMENTID','USERNAME','LOGIN_NAME']]; function traverse(datas) { for (const data of datas) { result.push([data.DEPARTID, data.DEPART, data.UPDEPARTMENTID]); if (data.CHILDREN) { traverse(data.CHILDREN); } } } traverse(data); const buffer = xlsx.build([{ name: "部门信息", data: result }]); fs.writeFileSync("department.xlsx", buffer, "binary");