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?

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