topic UC Volumes: writing xlsx file to volume in Data Engineering

UC Volumes: writing xlsx file to volume

DylanStout — Mon, 03 Jun 2024 14:25:13 GMT

How to write a DataFrame to a Volume in a catalog?

We tried the following code with our pandas Dataframe:

dbutils.fs.put('dbfs:/Volumes/xxxx/default/input_bestanden/x test.xlsx', pandasDf.to_excel('/Volumes/xxxx/default/input_bestanden/x test.xlsx'))

This results in the error:

([Errno 95] Operation not supported)

pandasDf.to_excel('/Volumes/xxxx/default/input_bestanden/x test.xlsx'))

Mister-Dinky — Wed, 25 Sep 2024 09:35:19 GMT

Did you use an AI to create this answer? You are posting a solution that is irrelevant to the question asked.

Itay_Wagner — Mon, 07 Oct 2024 09:53:29 GMT

Hi, did you find a solution that works? I'm having this same issue

NandiniN — Thu, 09 Jan 2025 10:55:38 GMT

I was able to upload, using

dbutils.fs.cp('/FileStore/excel-1.xlsx', 'dbfs:/Volumes/xxx/default/xxx/x_test.xlsx')

Maybe space in the name is causing an issue for you.