idea read Excel Named Ranges in ArcGIS Pro Ideas

read Excel Named Ranges

BenLeslie1 — Mon, 10 Jun 2024 16:50:25 GMT

The Excel to Table tool doesn't seem to pick up Named Ranges from Excel. Please make it.

How silly of you to forget!

Re: read Excel Named Ranges

KimOllivier — Thu, 06 Feb 2014 06:47:20 GMT

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.

Re: read Excel Named Ranges - Status changed to: In Product Plan

DrewFlater — Fri, 07 Jun 2024 19:47:47 GMT

Re: read Excel Named Ranges - Status changed to: Implemented

MargaretCrawford — Tue, 12 Nov 2024 16:34:06 GMT

This is implemented in ArcGIS Pro 3.4.

Go to Your Ideas in ArcGIS Pro 3.4 to see other ideas implemented this release and check out the What's New help to learn about everything that is new and improved in ArcGIS Pro 3.4.