The Esri Community
Esri Technical Support
Esri Technical Certification
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 ...
Vintage Business Summary data and Shapefiles
support ArcGIS Online Assistant
Kevin's Custom WAB Widgets
Extract Feature Attachments
Collector - The Aurora Project