cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Get Started Discussions
Start your journey with Databricks by joining discussions on getting started guides, tutorials, and introductory topics. Connect with beginners and experts alike to kickstart your Databricks experience.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Pandas .to_excel not saving to workspace

Ramonrcn
New Contributor III

Hi!

I was always able to export pandas datasets to my workspace on databricks, just like in a local machine using df.to_excel('filename', index=False).

but since i got some permissions updates to some new catalogs, when i try to export a dataset using .to_excel the cell runs ok, but the file isn't created nowhere in my workspace. Even when i tried some known working previous notebooks, the cell runs but no files are created.

any suggestions on how to solve this issue?

1 ACCEPTED SOLUTION

Accepted Solutions

Ramonrcn
New Contributor III

Just to update the situation, and to help anyone with the same problem in the future:
What hapened was thas my cluster was updated to use Unity Catalogs, and with that i had to specify the full path to my workspace.

df_pandas.to_excel('/Workspace/Users/ramon.nogueira@docway.co/inner_path/file.xlsx')

View solution in original post

1 REPLY 1

Ramonrcn
New Contributor III

Just to update the situation, and to help anyone with the same problem in the future:
What hapened was thas my cluster was updated to use Unity Catalogs, and with that i had to specify the full path to my workspace.

df_pandas.to_excel('/Workspace/Users/ramon.nogueira@docway.co/inner_path/file.xlsx')

Join Us as a Local Community Builder!

Passionate about hosting events and connecting people? Help us grow a vibrant local communityโ€”sign up today to get started!

Sign Up Now