topic Re: modelbuilder read a file in Geoprocessing Questions

modelbuilder read a file

AngelaNicholson — Wed, 07 Jun 2017 23:33:26 GMT

Does modelbuilder have the capability to read data from an excel file and return the value back to the model ?

Re: modelbuilder read a file

DanPatterson_Retired — Thu, 08 Jun 2017 01:59:11 GMT

That would be a vague approach because in general you don't reference sheets or cells directly, but you can bring in an excel file into an Arc* table and then do your query from there Excel to table

Re: modelbuilder read a file

curtvprice — Thu, 08 Jun 2017 04:03:50 GMT

If you format your excel sheet so it is readable as a table, yes, you can read excel directly into Model Builder as a table.

There is a tool -- Get Field Value -- which will read a value from the first row of the table into a model element you can then use as a parameter to another tool.

Understanding how to use Microsoft Excel files in ArcGIS—Help | ArcGIS Desktop

Get Field Value—Help | ArcGIS Desktop

Re: modelbuilder read a file

DuncanHornby — Thu, 08 Jun 2017 15:45:03 GMT

There is a very good Blog about formatting Excel files so that they can be read by ArcMap, strongly recommend you read this first if you intend to store data in Excel.

Formatting an Excel table for use in ArcGIS | ArcGIS Blog

Re: modelbuilder read a file

WKDickson1 — Thu, 08 Jun 2017 15:46:38 GMT

Thanks for all the answers. got it figured out !

Re: modelbuilder read a file

AbdullahAnter — Mon, 12 Jun 2017 18:21:12 GMT

Could you mark this question as Answered?