kimsama/Unity-QuickSheet

How can i import datetime from excel?

Bian-Sh opened this issue · 2 comments

Bian-Sh commented

date format in excel: 2019/4/25 15:38:03
but when import into unity with string format, I get this : 43580.6514236111
and this string is meaningless.

so anyone can help me to solve this problem?
thank you

kimsama commented

HI,
Unfortunately, Unity-QuickSheet does not support and understand any data format under the given cell.
Even Excel has tremendous types of such a format, so it would be better and right direction directly converting on your side.
Thanks and hope this would help your issue.

Cheers,

Bian-Sh commented

HI,
Unfortunately, Unity-QuickSheet does not support and understand any data format under the given cell.
Even Excel has tremendous types of such a format, so it would be better and right direction directly converting on your side.
Thanks and hope this would help your issue.

Cheers,

get and thanks for your reply