I am trying to add an excel table to a map in ArcGIS Pro. It is a 2010 excel file. Simple no macros or anything. It won't load. I have tried everything from the help menu. Am I having problems because we only have ArcGIS Pro 2.1??? I have attached the excel file I am trying to use.
Maybe save your .xlxs as .xls and try it.....
Good habit to have!
I've made it a habit to always convert Excel to tables rather than trying to work with Excel natively. Just too much possibility for flakiness otherwise.
field names shouldn't begin with numbers
you had a whole load of 'errors' in the T_Flag column. I 'fixed' those by copying to a new field defined as 'Text', then copied the values back over the original field (so CHECK THEM!!! )
But Excel To Table in ArcGIS Pro worked
see the attached. I called it 'stuff', so as not to confuse it with the original.
That was it. I was wondering if I should do that. Thanks for the help. I don’t like excel either.
Michelle Couden
Cartographer
Certified GIS Analyst
TPP Wellness Contact
Transportation Planning and Programming
Traffic Analysis Section
(512)486-5136
Watch for Cyclists!
That failed as well. I am thinking of checking me table for spaces. That would cause errors. Can you think of anything else.
Have you tried using the Excel To Table tool? When I try to add your excel spreadsheet to a 2.3 ArcGIS Pro session I get:
However, If I convert it to a table first, the new table comes in just fine.
Work with Microsoft Excel files in ArcGIS Pro—Excel | ArcGIS Desktop
Personally, I have a love/hate relationship with excel: I love to hate it.....
Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
