News:

BB code in posts seems to be working again!
I haven't turned on every single tag, so please let me know if there are any that are used/needed but not activated.

Main Menu

Export Visio to Excel?

Started by lori, February 19, 2016, 05:15:53 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

lori

Does anyone know if Visio process maps with swimlanes can be exported to Excel?

Thanks for any and all suggestions! 

Ciberpro

I hope you have already found your answer.  If you have Visio Professional, you have access to all that functionality.  It works great, and you can also bring exported (and update/changed) data back from your Excel into Visio.  I assume you already discovered this.  Let me know if you want more information.

Clochette204

Hi,
Can you please expand on your answer?

I am trying to:
1) create Cross functional flowchart from an Excel Sheet (that works)
2) adjust the layout of the flowchart manually if necessary (beauty purposes  8))
3.1) EITHER make modification on the flowchart, then export the data in Excel (i.e. the same type of data that were initially imported)
3.2) OR make modification in the Excel, then update the flowchart (e.g. to add new swimlanes; move shapes from one swimlane to another; update text, update type of shape, etc.)

Unfortunately, I can't make 3.1 or 3.2 work.

In 3.1, I found the option to export flowchart report (Review-->Shape reports --> Flowchart) but it doesn't export all necessary information (such as Process Step ID, Description, Next Step ID, Connector Label, Shape Type).

And in 3.2, it doesn't update/change for instance Swimlanes (for instance in the first table, I had Functions A, B, and C, and in the next one I replaced the swimlanes with C, D, E).

Any help would be much appreciated  :)
Thanks!


Browser ID: smf (possibly_robot)
Templates: 4: index (default), Display (default), GenericControls (default), GenericControls (default).
Sub templates: 6: init, html_above, body_above, main, body_below, html_below.
Language files: 4: index+Modifications.english (default), Post.english (default), Editor.english (default), Drafts.english (default).
Style sheets: 4: index.css, attachments.css, jquery.sceditor.css, responsive.css.
Hooks called: 192 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1083KB.
Tokens: post-login.
Cache hits: 13: 0.00171s for 26,722 bytes (show)
Cache misses: 3: (show)
Queries used: 17.

[Show Queries]