Friday 16 February 2018

python - Can ArcGIS ModelBuilder open Excel file for manual editing, then feed those edits back into model?


I have been tasked with creating a model using ArcGIS ModelBuilder, that initially runs a couple of geoprocessing tasks, before then joining an Excel table to the result of those geoprocesses. However, the model needs to actually open the Excel file first, for the user to manually edit it, before the user then saves their edits and closes the file. It is then expected that the model will join this Excel file to the attribute table of a dataset (still part of the model) before the model continues on with a number of other geoprocessing tasks.


I include a high-level schematic outline below to help illustrate the point (I understand this might not make a lot of sense to start with).


The model would pause whilst the Excel file is edited, then resume once saved and closed


So the model would run, complete a couple of geoprocessing tasks, pause to open an Excel file, wait for the user to edit it, save it and close it, before resuming to join that Excel file to an attribute table and then running a number of other geoprocessing tasks.


I should imagine this would require incorporating a Python script or two into the model. Currently though I am just interested to know whether the concept is actually possible or not.




No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...