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 ?
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 (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