Welcome to yEd Q&A!
Here you can ask questions and receive answers from other members of the community and yEd developers. And you can tell us your most wanted feature requests.

Categories

Creating an Diagramm from a Excel Treestructure

0 votes

Hello together,

i am trying to create an diagram from an product structure that i have in an excel file.

The structure of the data is like these

Ldf. Nummer  ArtikelNr Label
1 110 A1
1.1 111 A2
1.1.1 112 A3
1.1.1.1 113 A4
1.1.1.1.1 114 A5
1.1.1.1.1.1 115 A6
1.1.1.1.1.1.1 116 A7
1.1.1.1.1.1.1.1 117 A8
1.1.1.1.1.1.1.1.1 118 A9
1.1.1.1.1.1.1.1.2 119 A10
1.1.1.1.1.1.1.1.2.1 120 A11
1.1.1.1.1.1.1.1.2.1.1 121 A12
1.1.1.1.1.1.1.1.2.2 122 A13
1.1.1.1.1.1.1.1.2.3 123 A14
1.1.1.1.1.1.1.1.2.4 124 A15
1.1.1.1.1.1.1.1.2.5 125 A16
1.1.1.1.1.1.1.1.2.6 126 A17
1.1.1.1.1.1.1.1.2.7 127 A18
1.1.1.1.1.1.1.1.3 128 A19
1.1.1.1.1.1.1.1.3.1 129 A20
1.1.1.1.1.1.1.1.3.2 130 A21
1.1.1.1.1.1.1.1.3.3 131 A22
1.1.1.1.1.1.1.1.3.4 132 A23
1.1.1.1.1.1.1.1.3.5 133 A24

Would it be possible to create automaticly an diagram from these data (excel file)? Like an hierarchic structure? I have not get it until now :-( So i have no seperate colum with start and target identifier.

If i try to create it its shows me no edges. Is it possible for yed to proceed datas in these form, or must i change it like "from to"?. Can anyone help me?

Many thanks

 

Pascal

in Help by

1 Answer

0 votes

What kind of structure are you expecting from the given data? E.g. suppose you have nodes representing lines

1.1.1.1.1.1.1.1 117 A8
1.1.1.1.1.1.1.1.1 118 A9
1.1.1.1.1.1.1.1.2 119 A10
 

Should those be chained one after the other because of the subsequent ArtikelNr (i.e. A8 -> A9 -> A10) or should A8 get connected to both A9 and A10 due to Ldf. Nummer for A8 being the prefix for Ldf. Nummer for A9 and A10?

In any case you need to tell yEd the desired structure of the generated diagram. Hence you need to add an additional column that you can use to designate target IDs.

by [yWorks] (151k points)
Legal Disclosure | Privacy Policy
...