Select to view content in your preferred language

Treat Excel integer fields as INT, not DOUBLE (by default)

244
0
01-08-2024 09:08 PM
Status: Open
Labels (1)
Bud
by
Esteemed Contributor

ArcGIS Pro 3.2.1

I have an Excel .XLSX spreadsheet that I want to use in ArcGIS Pro:

Bud_0-1704776592824.png

When I navigate to the spreadsheet in Catalog and open the Fields view, I see that ArcGIS Pro has guessed at the datatypes.

Bud_1-1704776593020.png

Those datatypes aren't quite right. The integer fields have been interpreted as doubles. 

Ideally, I would like ArcGIS Pro to loop through all the values in a number column, and if they're all integers, then treat the field as a LONG INTEGER column. I'd be willing to wait for ArcGIS Pro to do that processing if it meant the datatypes would be correct.

For example, if I import the spreadsheet into a geodatabase, it would be great to have the right datatypes by default.