Author Topic: Visio diagrams from Excel spreadsheet loaded with shape type/positions  (Read 331 times)

0 Members and 1 Guest are viewing this topic.

PF4VisioGuy

  • Full Member
  • ***
  • Posts: 100
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

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 3829
  • Ideas Visio-lized into solutions
Re: Visio diagrams from Excel spreadsheet loaded with shape type/positions
« Reply #1 on: August 18, 2018, 01:06:57 PM »
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

« Last Edit: August 18, 2018, 01:13:27 PM by wapperdude »
Visio 2019 Pro