UC Volumes: writing xlsx file to volume

DylanStout
Contributor

‎06-03-2024 07:24 AM - edited ‎06-03-2024 07:25 AM

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)

on

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

 
 
Preview file
13 KB
0 Kudos

Mister-Dinky
New Contributor II
In response to Retired_mod

‎09-25-2024 02:35 AM

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

0 Kudos

Itay_Wagner
New Contributor II

‎10-07-2024 02:53 AM

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

0 Kudos

NandiniN
Databricks Employee
Databricks Employee

‎01-09-2025 02:55 AM

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.
 
 
 
 
Preview file
43 KB
Preview file
86 KB
0 Kudos