Incorrect formatting of date column in excel sheet

[Dipeshgandhi131]

Am I using the newest version of the library?

• I have made sure that I'm using the latest version of the library.

Is there an existing issue for this?

• I have searched the existing issues

Current Behavior

I am having a delta table which I read and write it to excel file using com.crealytics:spark-excel_2.12:3.5.1_0.20.4

Some columns have date format but after writing and opening excel shows weird format for that column.
I have attached the screenshots

for eg: 2025-07-31 (databricks) changes to 25-7-31 0:00 (excel) . Is there a way to retain the format.

I was able to bypass it casting column values to string type but I don't want to do this since 100 of columns are present

Expected Behavior

No response

Steps To Reproduce

No response

Environment

- Spark version: 3.5.1
- Spark-Excel version: 0.20.4
- OS:
- Cluster environment

Anything else?

No response

[Dipeshgandhi131]

It can also be resolved by adding .option("dateFormat" , "yyyy-MM-dd") in write method but not sure if it is right way of resolving it

[nightscape]

Hi @Dipeshgandhi131, you checked the box that you are using the latest version of spark-excel, but you're actually not...