search

kimsama / Unity-QuickSheet

Unity-QuickSheet enables you to use spreadsheet file data within Unity editor.
http://kimsama.github.io/Unity-QuickSheet
MIT License
1.05k stars 190 forks source link

How can i import datetime from excel? #85

Closed Bian-Sh closed 3 years ago

Bian-Sh commented 3 years ago

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 3 years ago

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 3 years ago

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