topic pd.read_excel gets error when script tool runs in Python Questions

pd.read_excel gets error when script tool runs

Aнастасия88 — Wed, 08 Mar 2023 02:08:09 GMT

Hello people,

I cam across an error,

AttributeError: ValueObject: Get attribute __class__ does not exist

when I run the script tool, I will get the error for the line, "df = pd.read_excel(spreadsheet)"

This simple code to read the spreadsheet has not problem in Python IDE but it will fail with the error in script tool.

As I have not figure out the error message, any advice is much appreciated.

Thanks in advance for your help!

Re: pd.read_excel gets error when script tool runs

DanPatterson — Wed, 08 Mar 2023 03:20:25 GMT

Have you specified the full path to "spreadsheet".

perhaps the script tool hasn't specified the workspace/folder where it is to be found

Re: pd.read_excel gets error when script tool runs

Aнастасия88 — Wed, 08 Mar 2023 03:36:23 GMT

Thanks for our reply!

I am having this problem when running script tool on ArcGIS Pro. The full path is to be defined via the tool with parameter setting as below.

And the code for the script tool is simple as below.

import pandas as pd import arcpy def ScriptTool(spreadsheet): arcpy.AddMessage('Start') df = pd.read_excel(spreadsheet) name_values = df["Name"].unique() query = "Name IN {}".format(tuple(name_values)) arcpy.AddMessage(query) if __name__ == '__main__': spreadsheet = arcpy.GetParameter(0) ScriptTool(spreadsheet)

Re: pd.read_excel gets error when script tool runs

Mahdi_Ch — Wed, 08 Mar 2023 04:58:52 GMT

I'm new to Arcpy, but from scripting point of view, I can suggest you to put a print statement after this line

spreadsheet = arcpy.GetParameter(0)

to print(spreadsheet) and double check what you are passing to pandas.read_excel(). This should be either a str or path object, maybe arcpy.GetParameter(0) is not returning what you expect.

Re: pd.read_excel gets error when script tool runs

DanPatterson — Wed, 08 Mar 2023 09:36:24 GMT

if you are providing the path, did you try

spreadsheet = arcpy.GetParameterAsText(0)

Re: pd.read_excel gets error when script tool runs

Aнастасия88 — Wed, 08 Mar 2023 21:28:04 GMT

Thanks Mahgi_Ch for your reply!

It was a just my careless mistake in the code.

Re: pd.read_excel gets error when script tool runs

Aнастасия88 — Wed, 08 Mar 2023 21:34:12 GMT

Thanks Dan for pointing out!

That was my careless mistake, I excluded AsText somehow - it works now.

Apart from that, I have a question. A code using GetParameter(0) works in both Python window and Python IDE. But this does not work it the code is embedded in a Script tool. Do you know why this occurs?

Re: pd.read_excel gets error when script tool runs

DanPatterson — Wed, 08 Mar 2023 22:48:04 GMT

I am not sure, I use custom toolboxes rather than python toolboxes, so I can specify my parameter types there and I always use GetParameterAsText and let arcpy's behind the scenes handle any stuff from arcobjects conversions

Re: pd.read_excel gets error when script tool runs

Aнастасия88 — Wed, 08 Mar 2023 23:48:54 GMT

I see, thanks Dan!