How to export ArcMap model parameters to an Excel file?

Question

I have a model where the user inserts different model parameters like "Name", "Elevation", "Threshold A", "Threshold B" and so on. Based on this, features get selected, saved to .xls files where they feed a chart/diagram maker for a report. To these charts, I need to include (or link) the model parameters the user inserted. I would like to write them to an Excel file, but any table is fine.

I thought of writing those variables to a newly created GeoDatabase table with the Calculate Field Tool (the table already had its field names and data types according to the variables), but I'm not good in Python. It also said that the table had no records. I tried with another table with existing records by calculating the fields I had added, but without success.

Is there any (easy) way to export my variables to a list or table I can then export to Excel format?

Answer 1

I would resolve this by calling a small python script to write out to say a CSV file.

The following example is for ArcMap 10.6

The test model is as:

Note the parameters are preconditions to the tool, they need to exist before the tool executes

The Calculate Value tool is as:

Here is the code:

Expression:

SaveParameters("%Name%","%Elevation%","\n")

Note the inline substitutions are within quotes to pass them in as text and eol character needs to be passed in as ESRI have introduced a bug into the tool, which I have brought to their attention but seem unable to fix it.

Code Block:

def SaveParameters(name,ele,eol):
  myfile = open(r"c:\temp\params.csv","w")
  myfile.write("Name,Elevation" + eol)
  myfile.write(name + "," + ele)
  myfile.close()
  return True