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

exporting visio to Excel

Started by Dodge, November 11, 2008, 11:31:42 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Dodge

Hi all,

How do I export a visio drawing to Excel?  I don't need the file to be linked or editable, just in excel so that I can manipulate numbers around the drawing - Tried saving as a WMF/EMF file, but that seems to do the same as copy and paste in that the visio object then does not allow you to use excel by selecting individual cells with your mouse under the drawing - also tried setting the visio drawing as background in excel, but then it will not print the drawing

Thanks Rog

Paul Herber

Start Excel, save a new, blank document with a suitable name.

Visio menu Tools -> Add-ons -> Visio Extras -> Database Export Wizard
Choose the page(s), shapes etc, then choose Excel as the export type -> Next,
Choose the filename created above.
Set the Table name to something, say, 'zzz', this will create an Excel page called 'zzz'.



Electronic and Electrical engineering, business and software stencils for Visio -

https://www.paulherber.co.uk/

Paul Herber

P.S. If you don't create the blank file first then you will just get a 'File not Found' error if you just enter a file name and expect Visio to create it for you. This is, of course, as obvious as a totally non-obvious thing and is not mentioned at all in the help file.


Electronic and Electrical engineering, business and software stencils for Visio -

https://www.paulherber.co.uk/

Lars-Erik

#3
So basicly, you want the shape created in Visio to serve as a background in Excel? No more?

Cant you export the Visio document as a JPG and set it as "behind the text" in Excel

Lars

Edit: my bad :) that wont work.
Try this to get Excel to print background images

Olivia Camp

Hi Rog, I just happened to see this post here....

If you don't need to make any changes or include any attachments/materials in your file, then you may try a new way: import your visio file into some other free download or online diagramming tools like Edraw Max or Lucidchart, then export to Excel.

I have tried setting a drawing as a background in Excel, so you can have a try for the Edraw Max or Lucidchart. Or anyone else has suggestions? 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: 215 (show)
Files included: 34 - 1306KB. (show)
Memory used: 1126KB.
Tokens: post-login.
Cache hits: 13: 0.00160s for 26,722 bytes (show)
Cache misses: 3: (show)
Queries used: 16.

[Show Queries]