topic Re: How to export the output data in the Excel format into the dbfs location in Data Engineering

How to export the output data in the Excel format into the dbfs location

Heman2 — Sat, 10 Dec 2022 10:42:11 GMT

Is there any way to export the output data in the Excel format into the dbfs?, I'm only able to do it in the CSV format

Re: How to export the output data in the Excel format into the dbfs location

Harish2122 — Sat, 10 Dec 2022 11:02:03 GMT

@Hemanth A try this code.

import openpyxl

wb = openpyxl.load_workbook('/dbfs/PATH/test.xlsx')

ws = wb.active

for row in ws.iter_rows():

print([col.value for col in row])

ws['A1']='A1'

wb.save('/dbfs/PATH/test.xlsx')

# Load its modified version and print values

wb = openpyxl.load_workbook('/dbfs/PATH/test.xlsx')

ws = wb.active

for row in ws.iter_rows():

print([col.value for col in row])

Re: How to export the output data in the Excel format into the dbfs location

Hubert-Dudek — Sat, 10 Dec 2022 12:11:39 GMT

If you are on Azure just create a logic app (or Power Automate) which will be triggered by Rest API call and will do convertion.

If you want you can also save the dataframe directly to Excel using native spark code. It is really easy:

df1 = df.to_pandas_on_spark()
df1.to_excel("output.xlsx")

Re: How to export the output data in the Excel format into the dbfs location

Ajay-Pandey — Sat, 10 Dec 2022 17:28:45 GMT

Hi @Hemanth A databricks does not support excel format if you really want to export excel files you have to use python or pandas for the same.

Re: How to export the output data in the Excel format into the dbfs location

Sobreiro — Mon, 15 Jan 2024 19:13:06 GMT

The easiest way I fount is to create a dashboard and export from there. It will enable a context menu with options to export to some file types including csv and excel.

Re: How to export the output data in the Excel format into the dbfs location

haidereli — Fri, 23 May 2025 07:56:48 GMT

As shared above I tested it and worked fine for loading and updating and saving

import openpyxl

wb = openpyxl.load_workbook('Test.xlsx')

ws = wb.active

for row in ws.iter_rows():

print([col.value for col in row]) #show all data

ws['A1']='Data'

wb.save('Test.xlsx')