Given the "adjacent nodes table", Is it possible to convert it to a "Hierarchy graph" using Microsoft Office products such as Visio or Excel?
给定“相邻节点表”，是否可以使用Microsoft Office产品（如Visio或Excel）将其转换为“层次结构图”？
1 个解决方案
#1
0
The final structure should be something like: "ID | parentID | item" which you can use to draw automatically the diagram.
最终结构应该类似于：“ID | parentID | item”，您可以使用它自动绘制图表。
The parentID should be fairly easy to obtain, since it is the last but one non empty value in the adjacent tables.
parentID应该相当容易获取，因为它是相邻表中的最后一个非空值。
HTH, Y.
HTH，Y。
#1
0
The final structure should be something like: "ID | parentID | item" which you can use to draw automatically the diagram.
最终结构应该类似于：“ID | parentID | item”，您可以使用它自动绘制图表。
The parentID should be fairly easy to obtain, since it is the last but one non empty value in the adjacent tables.
parentID应该相当容易获取，因为它是相邻表中的最后一个非空值。
HTH, Y.
HTH，Y。