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

Visio Reports: Export to Excel sucks

Started by cactuslover, August 11, 2016, 01:50:03 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

cactuslover

The export to Excel always includes:
1) a merged header row, which is *useless* and impedes any analysis.
2) Huge font that is right justified, which I have to fix.

So, I have to remove the header row, set column widths to something reasonable (12), left justify, and change the font size.

Does anyone have a fix for this, besides the obvious of creating Excel macros?  Is Microsoft aware that it is wasting so much of my time on this?  Please share your thoughts.
--J

Yacine

You're absolutely right.
In fact the reports suck so much, that every one using them on a regular basis will write his own tools.

Here are some possibilities:
1) Reformat the excel sheet by means of a VBA macro within Visio. Launching the macro to be either done manually (convert a selected excel object) or automatically - haven't done this before, but could imagine that the appropriate event could be caught, then the reformating routine started.
2) Export you shape data to excel, then reformat within excel and re-import to Visio.
3) The "King path" ( ;) ) - Export the data to Access and profit there from its great report capabilities (grouping, calculations, etc.). For my part, I kept the reports outside the drawings and just attach the PDFs to the drawing. One could however think about pasting images (other other types) of the reports back into Visio.

HTH,
Y.
Yacine

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: 153 (show)
Files included: 32 - 1207KB. (show)
Memory used: 1006KB.
Tokens: post-login.
Cache hits: 13: 0.00129s for 26,764 bytes (show)
Cache misses: 2: (show)
Queries used: 16.

[Show Queries]