Visio diagrams from Excel spreadsheet loaded with shape type/positions

Started by PF4VisioGuy, August 18, 2018, 04:49:24 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

PF4VisioGuy

Hi guys

I have a spreadsheet that contain the following:
-shape name
-XY coordinates for the shape
-text
-width,height (squares or circles)
-style (rounded corners for some of the rectangles

for connectors
-text
XY start
XY end

How can I create the corresponding Visio diagram ?

wapperdude

Basically, use the page drop method.

Code would loop thru Excel file, for example by rows, get the type of shape, get coordinates, drop shape. Move to next row, repeatedly.

Are you just dropping the connector, or do they also need to be glued?  If manually gluing, then additional coding necessary.  Need to identify from and to shapes and whether or not gluing is to connection point or walking glue.

See http://visguy.com/vgforum/index.php?topic=8431.msg36988;topicseen#msg36988.  See last couple replies for examples.

Another, probably better approach, might be Data Visualizer for Visio.  Just Google. 

Wapperdude

Visio 2019 Pro