the "node list-section" doesn't work well by importing from xls

Question

Hello everyone,

I've got a problem when i try to import an adjacency matrix from xls. The graph it self is properly imported, but i want to add attributes to the nodes other than the label (which is properly recognized in the first column or row of the matrix). I tried to realize this by adding to other columns besides my matrix containg the nodes labels and the additional attributes. Then i tried to use the "node list section" of the import dialog. 

Curiosly the additional attributes are recognized (i can see them in the view section), but when i finally import the graph, to sets of nodes are created, one containing the nodes with the desired labels and edges to the right nodes, and another set with nodes containing the right attributes.

Here is my matrix,

 

Name	U1	U2	U3	V1	V2	W1	W2	W3	W4			Name	Rank
U1				3	8							U1	150
U2				2	7							U2	200
U3				5	2							U3	70
V1						2	6	3	7			V1	80
V2						1	7	5	3			V2	60
W1	4	7	4									W1	100
W2	8	4	8									W2	120
W3	2	2	6									W3	30
W4	7	6	2									W4	80

 Here is the imported result:

 

The nodes arranged in the two lines contain the correct "Rank"-attribute.

What do i do wrong? Or can the Node-list even be used for this purpose? If not - how can i manage to project an attribute-list to the nodes of my graph, without hacking too much xml code?

Thank you very much for your help, 

5ilver

Answer 1

It's definitely possible to combine the data from the adjacency matrix and the node list since it works for me with your example. Please make sure that

• the names of the nodes are exactly identical (no additional spaces etc.) in both parts,
• the adjacency data range includes the node names in column A and row 1,
• the settings Node IDs in First Row and  ... First Column are enabled,
• the first column of the node list is specified as Column of Node IDs.

Since there is a bug in the Excel import in yEd 3.8, the node list must start in cell A1. Therefore, I propose to copy the node list to a different sheet in the file. This problem will be fixed in the next version and does not affect the combination of data from different parts.

 

Hope this helps!  Please let me know if you have any further questions.