search

crealytics / spark-excel

A Spark plugin for reading and writing Excel files
Apache License 2.0
449 stars 145 forks source link

[BUG] Incorrect date formatting if I indicate sheet Spark Read Excel #818

Open violetareimer opened 6 months ago

violetareimer commented 6 months ago

Is there an existing issue for this?

Current Behavior

I have detected what appears to be an error with the sheet selection option in pyspark, I don't really understand the reason but when I read an Excel indicating the first sheet it formats the date incorrectly. When I don't indicate it, it formats correctly.

imagen-withoption imagen-withoutoption

Expected Behavior

No response

Steps To Reproduce

No response

Environment

- Spark version:spark version 3.3.2
- Spark-Excel version:com.crealytics:spark-excel-2.12.17-3.2.2_2.12:3.2.2_0.18.1
- Cluster environment: databricks
- Library souce: Maven, Coordinates com.crealytics:spark-excel_2.12:3.2.1_0.16.5-pre1

Anything else?

No response

nightscape commented 6 months ago

Can you try the newest version (0.20.3) and also the version using .format("excel")?