nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

pd.read_excel gets error when script tool runs

Aнастасия88

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!

Find more posts tagged with

Accepted answers

danretired

if you are providing the path, did you try

spreadsheet = arcpy.GetParameterAsText(0)

All comments

Aнастасия88

I see, thanks Dan!

danretired

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

Aнастасия88

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?

Aнастасия88

Thanks Mahgi_Ch for your reply!

It was a just my careless mistake in the code.

danretired

if you are providing the path, did you try

spreadsheet = arcpy.GetParameterAsText(0)

Mahdi_Ch

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.

Aнастасия88

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)

danretired

Have you specified the full path to "spreadsheet".

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

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.