topic Re: i can list out the file using dbutils but can not able to read files in databricks in Data Engineering

i can list out the file using dbutils but can not able to read files in databricks

MohammadWasi — Tue, 07 May 2024 06:46:06 GMT

I can list out the file using dbutils but can not able to read files in databricks. PFB in screenshot. I can able to see the file using dbutils.fs.ls but when i try to read this file using read_excel then it is showing me an error like "FileNotFoundError: [Errno 2] No such file or directory: '/FileStore/xxx/abcd.xls'". I used to read excel file as

"df_mem = pd.read_excel('/FileStore/xxx/abcd.xls', engine='openpyxl', sheet_name = 'Sheet 1')"

Re: i can list out the file using dbutils but can not able to read files in databricks

MohammadWasi — Tue, 07 May 2024 10:04:52 GMT

Thanks @Retired_mod for your reply, Unfortunately I used path as variable in my code but again showing same error. PFB in screenshot.

Re: i can list out the file using dbutils but can not able to read files in databricks

MohammadWasi — Tue, 07 May 2024 11:14:17 GMT

I am using '.xls' format only.

Re: i can list out the file using dbutils but can not able to read files in databricks

MohammadWasi — Tue, 07 May 2024 11:30:00 GMT

Hi @Retired_mod I changed file in .xlsx format but again got the same error as above.

Re: i can list out the file using dbutils but can not able to read files in databricks

BenjaminJacquet — Fri, 06 Jun 2025 09:24:11 GMT

Hello @MohammadWasi did you finally figure out what the problem was? I am encountering the exact same issue