Gradientangleğor when the fillcolor contains two colors (like #555555:#FFFFFF)Ĭolor line color. Style (dropdown) select one of the combination of available graphviz shape stylesįillcolor when the style contains the word "filled" then this is the fillcolor. Shape (dropdown) select one of the available graphviz shape types use html rgb color wiht preceding #įixedsize boolean. # third Sheet: Clusters (graphviz clusters)įill out this sheet with all listed clusters the following way:Ĭol B: (dropdown) the type of the cluster (defined in sheet seven: Enum_Cluster_type)įill out this sheet with listed clusters the following way:Ĭol A: (dropdown) The name of the parent(contaiing) clusterĬol B: (dropdown) The name of the child(contaiined) cluster)Ĭontains all required node types and their graphviz characteristicsįontcolor of the text. nodes with the same RankID which are in the same cluster or placed adjacent to anotherĬol x: you can add any column you want after col H for your own purpose.Ĭontains all relations that exist between listed nodes in a consumerconsumed (or vice versa if you like) releationshipįill out this sheet with all listed nodes the following way:Ĭol A: (dropdown) the name(.version) of the consuming(right or top) nodeĬol B: (dropdown) the name(.version) of the providing(left or bottom) nodeĬol C: (dropdown) The edge type (defined in sheet six: Enum_Edge_type) just forget about this but don't overwrite this.Ĭol D: (dropdown) the node type (defined in fifth sheet Enum_Edge_type)Ĭol E: (optional) the cluster in which the node resides.Ĭol F: concatenation of name, version, type and cluster to assure uniqueness.Ĭol H: rankID. whole numbersĬol C: hidden concatenation of name and version. tenth sheet: Settings - Settings for the excel-to-graphviz tool itselfįill out this sheet with all concerned nodes the following way:Ĭol B: (optional) the node version (not the technical version). ninth sheet: GVGraphAttributes - Grpahviz graph attributes eight sheet: GVVariables - Graphviz node, edge and cluster type variables seventh sheet:Ğnum_Cluster_type - to define cluster types (used in clusters sheet) sixth sheet: Enum_Edge_type - to define edge types (used in edges sheet) fifth sheet: Enum_Node_type - to define node types (used in nodes sheet) fourth sheet: Cluster_Structure - to define hierarchy of clusters third sheet: Cluster - to define clusters Graphviz bin on your path (windows) (recommended) a grapviz file: *.gv that can be edited with a graphviz editor (or something like notepad++) vba macros that automatically generate dropdown boxes
The tool consists of a macro enabled excel workbook (xslm) with 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.
The same excel vba macro generates the graphviz image using the graphviz description file and library. Using the excel vba macro you create the graphviz description file. See Using excel tables you define nodes, edges and clusters. This tool generates "flow" images based on Grapviz from excel.
#GRAPHVIZ DEFINITION UPDATE#
automatic update of node identifier and edges after unique node identifier option change option to unclude node type and cluster name in unique node identifier (data sheet settings: nodeTypeAsIdentifier, clusterAsIdentifier) automatic update of node identifier and edges after node name change Comments and feature requests: new with this update
0 kommentar(er)
