Menu

Home

Matthijs Castelli
Attachments
cluster.PNG (5587 bytes)
edge.PNG (22694 bytes)
node.PNG (7839 bytes)

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:


Related

Wiki: sheets

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.