cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

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

pkgltn
New Contributor III

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?

1 ACCEPTED SOLUTION

Accepted Solutions

pkgltn
New Contributor III

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

View solution in original post

2 REPLIES 2

Aviral-Bhardwaj
Esteemed Contributor III

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

pkgltn
New Contributor III

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
Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.