Importing date and time from an excel file to matlab

Question

saadatnk8 2015-10-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/249172-importing-date-and-time-from-an-excel-file-to-matlab

回答： Peter Perkins 2015-10-22

I have an excel file with data that looks like this

Date  Time  PM10 
5/29/14  6:01  0.148
5/29/14  6:03  0.148
5/29/14  6:05  0.121
5/29/14  6:07  0.123
5/29/14  6:09  0.169
5/29/14  6:11  0.129
5/29/14  6:13  0.124

I want to import it into matlab as table such that mytable.Date would be the first column, and mytable.Time would be second column in the same format as in the excel file and mytable.PM10 would be the third column. I am currently using this code.

PM10data = readtable('PM10 data June 2014 - September 2015.xlsx');

However, the output I get looks like this

'5/29/2014'  0.250775462962963  0.148000000000000
'5/29/2014'  0.252164351851852  0.148000000000000
'5/29/2014'  0.253553240740741  0.121000000000000
'5/29/2014'  0.254942129629630  0.123000000000000
'5/29/2014'  0.256331018518519  0.169000000000000
'5/29/2014'  0.257719907407407  0.129000000000000
'5/29/2014'  0.259108796296296  0.124000000000000

I realize that it converts the time into a datenum but I want it to be a string. How do I fix this? Thank you!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Martin Schätz 2015-10-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/249172-importing-date-and-time-from-an-excel-file-to-matlab#answer_196412

在 MATLAB Online 中打开

Hi, you can use datestr() function

>> datestr(0.250775462962963)
ans =
   6:01 AM

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

saadatnk8 2015-10-22

在 MATLAB Online 中打开

Hi Martin, yes the datestr function works for one individual value, but if I do it for the whole array, I get the following error

Subscript indices must either be real positive integers or logicals.
Error in formatdate (line 158)
            month = char(strrep(month(dtvector(:,2)), '.', '')); %remove period
Error in dateformverify (line 32)
S = char(formatdate([y,mo,d,h,minute,s],dateformstr,islocal));
Error in datestr (line 194)
S = dateformverify(dtnumber, dateformstr, islocal);