0
votes

I'm using Databricks on Azure and am using a library called OpenPyXl.

I'm running the sameple cosde shown here: and the last line of the code is:

wb.save('document.xlsx', as_template=False)

The code seems to run so I'm guessing it's storing the file somewhere on the cluster. Does anyone know where so that I can then transfer it to BLOB?

1
It is probably saving it in DBFS, more info here - Andrea

1 Answers

0
votes

To save a file to the FileStore, put it in the /FileStore directory in DBFS:

dbutils.fs.put("/FileStore/my-stuff/my-file.txt", "Contents of my file")

Note: The FileStore is a special folder within Databricks File System - DBFS where you can save files and have them accessible to your web browser. You can use the File Store to:

enter image description here

For more detials, refer "Databricks - The FileStore".

Hope this helps.