spark-excel icon indicating copy to clipboard operation
spark-excel copied to clipboard

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

Open violetareimer opened this issue 2 years ago • 1 comments

Is there an existing issue for this?

  • [X] I have searched the existing issues

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

violetareimer avatar Dec 15 '23 20:12 violetareimer

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

nightscape avatar Dec 18 '23 18:12 nightscape