The Esri Community
Services & Programs
GeoNet Resource Hub
to create and rate content, and to follow, bookmark, and share content with other members.
read Excel Named Ranges
Idea created by
on Jan 13, 2014
2 votes up
0 votes down
No one has voted against this idea
The Excel to Table tool doesn't seem to pick up Named Ranges from Excel. Please make it.
How silly of you to forget!
This content has been marked as final.
Show 1 comment
(Required, will not be published)
Feb 5, 2014 10:47 PM
At 10.2.1 Esri include two Python modules XLRD and XLWT which provide an API to read and write Excel spreadsheets, so it is unlikely that the ExcelToTable will be fixed because we can do it ourselves.
What should have happened is that the developer used these tools to read the structure and metadata in the Excel file and present a dialog to choose the sheets, named ranges and also a fieldmapping to alter the terrible defaults of 255 characters and floating point numbers for everything.
Show 0 Likes
Retrieving data ...
Add field to feature service
ServiceFeatureTable.QueryFeaturesAsync() error - Invalid URI: The Uri string is too long
add a custom image and a label for features
Uploading a new service