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

Tan, Yurong (OIG) Yurong.tan at va.gov
Tue Jun 5 11:42:05 EDT 2012


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