topic Re: VSCode unable to read file even though it's there in the defined path in ArcGIS Pro Questions

VSCode unable to read file even though it's there in the defined path

Ed_ — Thu, 29 Feb 2024 16:25:57 GMT

So I exported the code from a model builder model in ArcGIS Pro 3.1. I then opened the code in VScode to firstly see whether the code is running fine from VScode or not.

So the code fails where it has to read an xlsx file, even though the file does exist in the location path defined.

Is this a path issue? How can I fix this?

Error:

ERROR 000732: Input Excel File: Dataset \bc\efs\PowerBI\EPGMD\INNOVATION UNIT\CulturalArts\Grants.xlsx does not exist or is not supported

Code line:

Grants_xlsx = "\\bc\efs\PowerBI\EPGMD\INNOVATION UNIT\CulturalArts\Grants.xlsx" # Process: Excel To Table (Excel To Table) (conversion) Grants_ExcelToTable = "O:\\psd\\Ed\\GeocodeProject\\ModelGeodatabase.gdb\\Grants_ExcelToTable" arcpy.conversion.ExcelToTable(Input_Excel_File=Grants_xlsx, Output_Table=Grants_ExcelToTable, Sheet="Grants")

File location:

Re: VSCode unable to read file even though it's there in the defined path

CodyPatterson — Thu, 29 Feb 2024 16:29:53 GMT

Hey @Ed_

In your error I see that the first \ in your line isn't showing as double, you may try this:

Grants_xlsx = r"\\bc\efs\PowerBI\EPGMD\INNOVATION UNIT\CulturalArts\Grants.xlsx"

This may take in the second \.

Hope that helps!

Cody

Re: VSCode unable to read file even though it's there in the defined path

Ed_ — Thu, 29 Feb 2024 16:39:51 GMT

Yup that did it, cheers for the super quick response 🙂

Re: VSCode unable to read file even though it's there in the defined path

CodyPatterson — Thu, 29 Feb 2024 16:40:34 GMT

Hey @Ed_

No problem at all, glad to help out!

Cody