excel in ArcMap as an object (either in dataview or layout)

1653
6
02-17-2013 08:34 AM
MehrdadZarei
New Contributor II
there are few methods to add tables sitting in an excel sheet into ArcMap
- in excel file select the area are intended to add and copy to clip board then in ArcMap paste it which comes in as an image
  you may want to re-size the inserted image to what you prefer. this method is fine but the downsize is there is no connection to the original excel sheet, meaning updating the original table in the excel file you must re-insert your table in ArcMap
- in ArcMap you may insert excel table by going to menu/insert/object/Create New/Microsoft office Excel Worksheet
then copy the table you want to bring into ArcMap into this new worksheet, close it and the table would appear in your ArcMap.
This method is good insence of by updating the excel data the table in your ArcMap would be updated as well

- in ArcMap you may insert excel table by going to menu/insert/object/Create New/Create From File using the link option find the excel file and insert the worksheet into your ArcMap
in this method if you update the excel file the table in ArcMap would be updated as well, but there is one issue. when you insert the excel file using this method the whole sheet would be inserted. if you have many tables in that worksheet and you would like to insert them one by one using "Name Range" (specific rows and columns) you are not able to.

I am looking for a way to insert tables into ArcMap from one excel worksheet not as whole but as specifed rows and columns as I needed

Is there any add-on, VB or Python scripts for this?
Tags (2)
0 Kudos
6 Replies
SteveGazdik
New Contributor
Have you received any word on this?  I'm trying to accomplish the same task and I haven't been able to locate any help on the subject. 

Thanks in advance
0 Kudos
RobertBorchert
Frequent Contributor III
Have you tried creating your tables as geodatabase tables instead of as excel.

then you can use the data loader to add new data to the existing table and you can use a query in the data loader to specify what gets loaded.
0 Kudos
MehrdadZarei
New Contributor II

No, I haven't got anything except the one right after your comment.
Our problem is not relating to uploading data but showing some excel tables on our maps.
I receive individual data tables in one excel sheet and need to insert them one by one onto may maps.
the other problem is sometimes the cells in those tables gets updated (value, font color, background shade, ...). it was nice if when opening the mxd those changes would be reflected without reinserting the tables.
thank you

0 Kudos
StephanieFinamore
New Contributor II

Has anyone had any progress with this issue?  I am looking to accomplish the same thing - need to preserve excel formatting, and excel data needs to be linked so it can be updated.  Thanks!

0 Kudos
RebeccaStrauch__GISP
MVP Emeritus

Since this is such an old thread, you may want to start a new question and include the version of ArcGIS and Excel that you are using.  Also, if you have tried anything else yet.  If you put it as a question, you will get more views/responses (because this was converted from the old forums, it is a discussion not a question now)

https://community.esri.com/community/help-and-feedback/blog/2016/08/15/community-news-and-tips-how-t...

and for posting code  https://community.esri.com/docs/DOC-8691-posting-code-with-syntax-highlighting-on-geonet?sr=search&s...

0 Kudos
MehrdadZarei
New Contributor II

Thank you for letting me know.

Sincerely

Mehrdad Zarei M.Sc., P.Geo., GISP | GIS Analyst |

mehrdad.zarei@arcadis.com<mailto:mehrdad.zarei@arcadis.com>

Arcadis | Arcadis Canada Inc.

4005 Hickory Drive L4W 1L1 Mississauga ON | CANADA

T. +1 905 614 1978 | M. +1 905 614 1979

Professional Geoscientist / P.Geo.-ON, 2357

Certified Geographic Information Systems (GIS) Professional (GISP) / 90604

Connect with us! www.arcadis.com<http://www.arcadis.com/> | LinkedIn<https://www.linkedin.com/company/arcadis-north-america?trk=biz-companies-cym> | Twitter<http://www.twitter.com/arcadis_us> | Facebook<https://www.facebook.com/ArcadisNorthAmerica>

<https://www.arcadis.com/en/united-states/who-we-are/download-our-app-connect-with-us-/cookie-wall/?utm_source=download&utm_medium=web&utm_campaign=Connectana>

Be green, leave it on the screen.

0 Kudos