shrug-l: Cut&Paste Excel (2007) tables to ArcMap ...

Tan, Yurong (OIG) Yurong.tan at va.gov
Wed Jun 6 11:22:08 EDT 2012


Thank you for sharing the info.  

It is still painful to recreate a table file in ArcMap from a CVS file.  Here is how I managed to survive this through the following steps:
1.  Create the table in Excel exactly the way you want it to look like.
2.  Figure out the exact size of the table in the map (map layout).
3.  Open PowerPoint and set a page size that is identical to the size of the table showing in the map.   
4.  Copy the table from Excel and paste it to PowerPoint and same the PP file (this is kind of to convert the table to an image).
5.  Copy the table from PowerPoint and directly paste it to ArcMap in layout view.  

These steps appeared to save my day.  It appears to me that the table format settings are lost if a resizing is needed once the table is brought to ArcMap. 

Thanks and cheers!
Yurong


-----Original Message-----
From: Porter, William B. [mailto:william.porter at famu.edu] 
Sent: Wednesday, June 06, 2012 11:12 AM
To: Tan, Yurong (OIG); Stone, Holly
Cc: shrug-l at lists.dep.state.fl.us
Subject: RE: shrug-l: Cut&Paste Excel (2007) tables to ArcMap ...

I spent many hours reading through ArcGIS 10 Documentation about its link to MS files and Googling for outside solutions.
In the end I found ESRI suggested converting to dumb image files [screen printing or PDF] losing the ability to easily add useful numeric tables.  

I ended up exporting to CSV [comma delimited text files],  editing in Kedit [the best ASCII editor in the world] and adding them as text with non-proportional font - the same as I did in ArcInfo 6 on a Unix box.  

ESRI dropped the ball on Windows and MS compatibility. That they even speak of it in their documentation is a little embarrassing when you see the complete lack of function.


William  B. Porter     william.porter at famu.edu     850 412 5972
Application Coordinator for GIS / Infrastructure Florida A&M University EIT / GIS Perry-Paige, West Wing Ground floor, Office 1 -D
1740  S. M L King  BLVD
TLH FL 32307



-----Original Message-----
From: shrug-l-bounces at lists.dep.state.fl.us [mailto:shrug-l-bounces at lists.dep.state.fl.us] On Behalf Of Tan, Yurong (OIG)
Sent: Tuesday, June 05, 2012 11:42 AM
To: Stone, Holly
Cc: 'SHRUG-L at lists.dep.state.fl.us'
Subject: RE: shrug-l: Cut&Paste Excel (2007) tables to ArcMap ...

Thanks you!  Appreciate your response.  

ArcMap (ArcGIS) is supposed to work seamlessly with Office and it did not behave like that.  Being able to work seamless with MS Office was one of the main objectives when migrating to ArcGIS from some early platforms.  Does ESRI drop the ball or can some ESRI folks on this thread shed some lights on this?     

Thanks
Yurong

-----Original Message-----
From: Stone, Holly [mailto:Holly.Stone at freshfromflorida.com]
Sent: Tuesday, June 05, 2012 11:30 AM
To: Tan, Yurong (OIG)
Subject: RE: shrug-l: Cut&Paste Excel (2007) tables to ArcMap ...

Hello,

If you are talking about pasting Excel tables into the map layout, I've run into the same problems.  I have been successful in converting the Excel spreadsheet to a PDF, exporting that to an image, and then pasting the resulting image into ArcMap, though.  It's somewhat cumbersome, but it seems to be the only way to keep all the formatting and not end up with strange letter jumbling in table.

Good luck!

Holly
-------------------------------------
Holly M. Stone, Environmental Specialist III Office of Agricultural Water Policy Florida Department of Agriculture and Consumer Services
1203 Governors Square Blvd, Suite 200
Tallahassee, FL 32301
(850) 617-1712
Holly.Stone at freshfromflorida.com


-----Original Message-----
From: shrug-l-bounces at lists.dep.state.fl.us [mailto:shrug-l-bounces at lists.dep.state.fl.us] On Behalf Of Tan, Yurong (OIG)
Sent: Tuesday, June 05, 2012 11:20 AM
To: 'SHRUG-L at lists.dep.state.fl.us'
Subject: shrug-l: Cut&Paste Excel (2007) tables to ArcMap ...

I have run to a wall lately in trying to Cut&Paste Excel tables to ArcMap.  Specifically, I am talking about losing all or some of the format settings (e.g. cell borders, cell background color, etc.) of a table when the table is cut from Excell and then pasted to ArcMap.  I even tried to Cut&Paste the table to PowerPoint (also 2007) first to kind of convert the table to an "image object" before another Cut&Pasting  it to ArcMap. I do not remember it worked like that before 10.

Anything to share?  Thanks

Yurong Tan
Office of Inspector General
Dept of Veterans Affairs
(352) 337-2375



More information about the SHRUG-L mailing list