topic Re: Load an Excel File (located in Databricks Repo connected to Azure DevOps) into a dataframe in Data Engineering

Load an Excel File (located in Databricks Repo connected to Azure DevOps) into a dataframe

pkgltn — Fri, 16 Dec 2022 10:38:06 GMT

Hi,

How can I load an Excel File (located in Databricks Repo connected to Azure DevOps) into a dataframe? When I pass the full path into the load method, it displays an error.

java.io.FileNotFoundException Has someone done it previously?

Re: Load an Excel File (located in Databricks Repo connected to Azure DevOps) into a dataframe

Aviral-Bhardwaj — Tue, 20 Dec 2022 14:10:06 GMT

Please give us exact file and code , we will try to debug it , I have done this multiple time, please share more details

Thanks

Aviral Bhardwaj

Re: Load an Excel File (located in Databricks Repo connected to Azure DevOps) into a dataframe

pkgltn — Tue, 20 Dec 2022 18:17:23 GMT

Hi,

Just managed to do it.

Upgraded the cluster to the latest version because Files in Repos only works in most recent versions of the cluster.
When loading the dataframe, specify the path as follows: file:/Workspace/Repos/user@email.com/filepath/filename.xlsx