How to use import spreadsheet to specify two or more types of node or edge?

Question

Is it possible with a spreadsheet import to enable yEd to show nodes with different colours and different edge types viz full line or dotted line as in the following test diagram?

I have found as a basic user the following guide and from that created the mindmap aide memoire.

https://www.youtube.com/watch?v=l-ktE8syWUI&feature=emb_rel_endqd

I am not a programmer and only capable of using the surface commands in yEd...thanks in anticipation.

Answer 1

Yes, it is possible to use yEd's Excel import to create diagrams with different types of node and edges. However, to do so you need to use yEd's properties mapper as well. The basic approach is the following:

1. Import your spreadsheet.
2. Create properties mapper configurations to adjust your node and edge styles as required.
3. On subsequent Excel imports, configure Excel Import to use the configurations created in step 2 (see tab "Presentation" in the Excel Import settings).

Please see chapters Import of Excel Files and Mapping Custom Properties to Visual Properties in the yEd Manual for further information. Aside from that there quite a lot of posts here in the forum on these two topics.

Comments

Thank you, Thomas. I missed the Mapping ...to visual properties chapter. Great!