nightscape/spark-excel

Can not parse Date

Kyofin opened this issue · 5 comments

Kyofin commented

My Execl is below:
image

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 commented

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 commented

@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 commented

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

Harivignesh3419 commented

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 commented

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

  • 😕1