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

[Heman2]

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

[Harish2122 · Accepted solution]

@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])

[Hubert-Dudek]

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")

[Ajay-Pandey]

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.

[Sobreiro]

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.