xdrawio is a script to render data from Excel worksheet to draw.io file format. From that, one can open in draw.io and export to other formats such as pdf, svg, png, ...
Currently, xdrawio support following templates to render data:
features: render all features of a software system, which will be grouped into domains, sub-domainsstatus: render data in status dashboard, suitable for rendering multi project status, where each project will go through set of same steps.roadmap: render feature roadmap of a software system
Need to run following command to install prerequisite python packages:
$ pip3 install pyparsing openpyxl jinja2Clone and install pyyoga - visit https://github.com/huuhoa/pyyoga
usage: generate.py [-h] [-d DEBUG] [-ps {A0,A1,A2,A3,A4,A5,A6}]
[-po {portrait,landscape}]
[-t {arch,features,roadmap,status}] [-o [OUTPUT]]
[--write_layout_tree WRITE_LAYOUT_TREE] [-lt LAYOUT_TREE]
[-e EXPERIMENT]
path
Render data to drawio file format.
positional arguments:
path path to xlsx file that contains team structure
optional arguments:
-h, --help show this help message and exit
-d DEBUG, --debug DEBUG
debug flag, when enable only print debug data, not
print drawio data
-ps {A0,A1,A2,A3,A4,A5,A6}, --page-size {A0,A1,A2,A3,A4,A5,A6}
page size, possible values: A0, A1, A2, A3, A4, A5, A6
-po {portrait,landscape}, --page-orientation {portrait,landscape}
page orientation, possible values: portrait, landscape
-t {arch,features,roadmap,status}, --type {arch,features,roadmap,status}
draw type, possible values: features, roadmap, status,
arch
-o [OUTPUT], --output [OUTPUT]
Output drawio file
--write_layout_tree WRITE_LAYOUT_TREE
Enable to write layout tree to a file, specified by
--layout-tree parameter
-lt LAYOUT_TREE, --layout_tree LAYOUT_TREE
File to store layout tree
-e EXPERIMENT, --experiment EXPERIMENT
Enable experiment new features
Enjoy!