Home

Excel To Graphviz Tool

The tool generates "flow" images or diagrams based on Grapviz from excel tables.

Using excel tables you define nodes, edges and clusters.



Using an excel vba macro the tool creates the graphviz (.gv) description file.
The same excel vba macro generates the graphviz images using the graphviz description file and graphviz library.
Image formats provided are: PNG, SVG and PDF

Knowledge of graphviz and it's possiblities is not required but for more in-depth knowledge of what you are doing you could read the dot guide which comes with the graphviz installation.

How does the tool work

The tool is a macro enabled excel workbook (xslm) with

• sheets that have to be filled out
• vba macros that automatically generate dropdown boxes
• a vba macro that generates the output:
  • a grapviz file: *.gv that can be edited with a graphviz editor (or something like notepad++)
  • a pdf containing the generated image
  • a png image
  • a sgv image

prerequisites

• Macro enabled Excel 2007+
• Graphviz installed on your system. It's free. http://www.graphviz.org/
• Graphviz bin on your path (windows) (recommended) or on sheet settings

Project Members:

• Matthijs Castelli (admin)