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.

Import Excel

0 votes

I have a List that looks something like this

 

TAGNAME Description Color Height Descripton_Bottom_Right Descripton_Bottom_Left
Anna Anna goes for a walk red 10 15 Dog
Tim Tim goes for a walk white 15 20 Cat
Andreas Andreas goes for a walk blue 10 22 Dog
Sara Sara goes for a walk orange 20 23 Dog
Markus Markus goes for a walk green 5 18 Cat

and I want to import this Excel to yed.

I want my nodes to look something like this, (but without excel line)

     
  Anna  
Dog Anna goes for a walk 15

I can import it but all the texts land on top of each other.

How do I define where the texts are placed in the import?

Same thing with Edges. I have one text that I want close to the source and one close to the Target. How do I do that?

Can I use the Color / Height columns to deside shape and Color of the Nodes?

 

Thank you so much, I think yEd is great!

 

Johanna

asked Aug 26, 2016 in Help by anonymous

1 Answer

0 votes
  1. Prepare a node where the labels are already properly positioned.
  2. Create a user-defined palette section and add your node as node template to said section.
  3. Prepare a properties mapper configuration that uses said node template and map properties "Description", "Description_Bottom_Right", and "Description_Bottom_Left" to the appropriate labels.
  4. In the Excel Import settings on tab "Presentation", enable option "Use Configuration" and specify your custom properties mapper configuration for option "Configuration".

Use the same approach for edges.

To apply color and height for nodes, add corresponding mappings to your properties mapper configuration.

 

Note:

To be able to create a properties mapper configuration, your diagram has to have custom properties. The easiest way to get the appropriate properties is to run the Excel Import once without a properties mapper configuration.

answered Aug 26, 2016 by thomas.behr [yWorks] (123,120 points)
Imprint | Privacy Policy