Reading excel sheets with arcpy script tool

CCampagna — Wed, 04 Sep 2024 19:00:03 GMT

I am trying to create a script with arcpy that reads several excel sheets within an .xlsx file, then returns the values of the specified cells in the sheets into an attribute table. When I run the tool, the error code returned states that No such file or directory exists to my specified file. A snippet of my code is as follows:

[...]

try:

file = arcpy.GetParameterAsText(0)

outputFC = arcpy.GetParameterAsText(1)

# ==========================================================================

# read how many sheets are in file

df = pd.read_excel(file)

# read number of columns and rows

columns = pd.read_excel(file, usecols='A,B,C,D,E,F,G,H')

while df['value'].sum > 0:

for rows in columns.iterrows:

GenInfo = df.iloc[13]

ConAssess = df.iloc[19]

Comments = df.iloc[24:33]

[...]

Re: Reading excel sheets with arcpy script tool

CodyPatterson — Wed, 04 Sep 2024 19:20:42 GMT

Hey @CCampagna

You may attempt to do an arcpy.AddMessage(file) just to make sure that it's catching the right link. Something may be causing an issue in the actual file system linkage.

Cody

topic Reading excel sheets with arcpy script tool in Developers Questions

Reading excel sheets with arcpy script tool

Re: Reading excel sheets with arcpy script tool