Can not parse Date

[Kyofin]

My Execl is below:

when I use spark-excel to read , the data is wrong.

df.show

+-----------------+
|         入住日期|
+-----------------+
|       3"月"3"日"|
|       3"月"7"日"|
|reserved-43901x1C|
|reserved-43905x1C|
|      3"月"10"日"|
|      3"月"10"日"|

[nightscape]

The other cells in that column don't look like dates, do they? You can only use the same kind of cell in one column.

[Harivignesh3419]

@nightscape : The issue seems to be because there is no dateParser unlike timeStampparser . What I propose is add another parameter option "dateParser" and use the corresponding format given there to convert to Date Type .

[nightscape]

@Harivignesh3419 sounds good! Do you want to give it a try?

[Harivignesh3419]

Sure @nightscape ! I will give an try . I see two branches master and main branch .Which branch should i start working with and give PR?

[nightscape]

main is the new default branch. For some reason I can't delete master...