Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I am trying to put a simple table of text (excel) into my layout and preserve cell formatting including alignment, borders and text sharpness. I've tried many approaches but nothing so far is satisfactory. BTW: ArcGIS 10.1

share|improve this question
1  
You say you have tried many approaches so far. Could you outline them so we have a better idea of your thought processes so far? –  sgrieve Oct 18 '12 at 7:54
    
FYI - In addition I've had some issues with exporting a PDF from ArcMap using tables that contain "rare" or unusual font styles. Seemingly random cells will have the characters ran together, or a ?, or some other symbol substituting for part or all of a word or number sequence. Solution: Use something common like Times New Roman or Arial. –  user23715 Nov 7 '13 at 0:27
add comment

2 Answers 2

I discovered the solution to this by accident a couple of weeks ago. It's so simple it's almost too good to be true:

Select the formatted cells of interest in Excel, Copy, then Paste into an active Arcmap Layout dataframe. Size and place to suit. Done.

To ensure you don't get any jpeg jaggies use the same font size in Excel as you would in Arcmap if it were directly placed text from the Drawing toolbar. The table on this map was formatted entirely in Excel, using data-driven conditional formatting, detail below:

table formatted with coloured background rows and symbol fonts

Limitations: The table is just a dumb graphic. If you see a spelling mistake or need to udpate it for next year you'll need to repeat everything (but that's the same for the native Arcmap embedded tables). To make repeated updates easier, export rather than copy the table (saving results in a model for quick repeat), and use saved styles and formatting rules everywhere possible in Excel.

I'm using ArcMap 10.1 and Excel 2010. It'd be interesting to hear if this a version specific thing or this has been around for awhile (and does this only work with MS Office?).

share|improve this answer
1  
After copying the formatted cells you can also go to the Edit menu in ArcMap and select 'Paste Special...' to choose the format, though .emf is the default and usually the best quality. –  AlmaThom Jun 3 '13 at 18:33
    
Thanks @almathom, I didn't know that. This means it might be possible, with hackery, to be able to actually edit the embedded graphic since EMF consists of vectors, bitmaps and real text. It also explains why the quality on resizing the graphics are better than I expected. –  matt wilkie Jun 3 '13 at 19:44
add comment

Have you been using the Online Help for Adding a table to a layout?

There's also quite a bit on getting the Appearance of the Table right, which you need to do before adding it to the layout, on the help for Understanding field properties, aliases, and table display options.

share|improve this answer
    
I have tried printing to PDF from Excel, saving as a jpeg from excel, bring the excel table in as a layer and adding the table to the layout, screen capturing and pasting. I've tried others things too, at this point I don't remember them all... I ended up making a table out of text boxes in layout view - pretty pathetic but it worked better than anything else. –  John Bean Oct 26 '12 at 19:37
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.