Insert Table to Map

2552
4
08-27-2012 07:18 AM
JamesHarrington
New Contributor III
Hello
I'm trying to insert an Excel table into a map data frame, and the cell values do not line up with the cells when this happens, is there any known solution to this?
Tags (2)
0 Kudos
4 Replies
AlexeyTereshenkov
Regular Contributor III
Hi James,

Do you go Layout > Insert > Object > Create from File > browsing to an Excel sheet file?
1) You could resave the Excel file to an .xls file if you deal with .xlsx file or vice versa.
2) Test inserting the sheet into a newly created .mxd document first.
0 Kudos
JohnSobetzer
Frequent Contributor
You may get better results copying and pasting the spreadsheet cells (perhaps with a "cushion" of surrounding cells) into ArcMap.  But even that approach can run into problems in exporting to pdf especially if after the paste one has to resize the table.  So in those cases we create a stamp in Acrobat and use Acrobat to add it to the map pdf.  Clumsy.
0 Kudos
JimW1
by
Occasional Contributor II
I suggest formatting in Excel and then 'Copy' and 'Paste Special' as a picture into ArcMap. I've given up on editable tables in the layout view.
0 Kudos
JamesHarrington
New Contributor III
I discovered a solution:
Insert table in data view. It will probably look messed up like the example above. If it prints like this, try this:
Cut the table, and paste it into layout view. Then cut and paste it back into data view. Resize as needed. It will most likely look screwed up again as in the example, but will print fine. I tried this with 10 tables in data view that needed editing and it worked on all of them.
0 Kudos