Why Matlab doesn't recognize the time variable from .xlsx file

6 次查看（过去 30 天）
Viktor G.
Viktor G. 2020-6-22
评论： Star Strider 2020-6-22
I need to have 1 information per second of the time, which is why i have to compare times and remove the unnecessary ones. But Matlab doesn't recognize the column with the Time variable, even though the formating in excel is done right. Can anyone help with this ?
  1 个评论
Rik
Rik 2020-6-22
What exact code are you using to read this excel file? Excel can be very picky about the locale settings. To reproduce your issue it may also be needed to know the language you have your OS set to (and the date/time settings), as well as the language your Office is set to. Thanks Microsoft...

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Star Strider
Star Strider 2020-6-22
I have no idea why datetime cannot import the time correctly in that format. The readtable function imports it a fractions of a day.
A small diversion into datevec and it works:
T1 = readtable('test.xlsx');
T1.Time = datetime(datevec(T1.Time), 'Format','HH:mm:ss'); % Original Table
T2 = table(T1.Date + timeofday(T1.Time), 'VariableNames',{'Date_Time'}); % Create New Variable
T2 = [T2 T1(:,3:end)] % Derived Table
and:
Sample = T2(1:10,:)
displays:
Sample =
10×3 table
Date_Time Angle Speed
____________________ _____ _____
01-Feb-2014 00:00:00 62 3.6
01-Feb-2014 00:00:00 62 3.8
01-Feb-2014 00:00:01 60 4.1
01-Feb-2014 00:00:01 59 4.2
01-Feb-2014 00:00:02 58 4.3
01-Feb-2014 00:00:02 60 4.3
01-Feb-2014 00:00:02 64 4.3
01-Feb-2014 00:00:03 63 4.3
01-Feb-2014 00:00:03 61 4.3
01-Feb-2014 00:00:04 61 4.3
The original ‘T1’ table keeps the dates and times in separate columns. The ‘T2’ table concatenates them.
.
  7 个评论
显示 5更早的评论
Viktor G.
Viktor G. 2020-6-22
What I meant obviously is that it doesn't work for me and that is probably because of a windows setting or somethig. No need for a snarky answer. Thank you for your help :)
Star Strider
Star Strider 2020-6-22
As always, my pleasure!
I have no control over any Windows settings other than my own.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Calendar 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by