How May I import date/time from Excel?

Question

Soli 2014-5-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/131199-how-may-i-import-date-time-from-excel

评论： Mahdi 2014-5-26

I have a time series in Excel sheet and would like to import it to MATLAB but the date variable becomes scientific numbers like this: 9.37500000000000e-05, 8.82352941176471e-05, 7.50000000000000e-05, 7.14285714285714e-05, I tried "datestr()" function to convert them into "mm/dd/yyyy" format but the output was "12 am" for all dates. How may I transfer date variable to MATLAB and have "mm/dd/yyyy" format?

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

请先登录，再进行评论。

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

Answer 1

Mahdi 2014-5-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/131199-how-may-i-import-date-time-from-excel#answer_138320

Have you looked at this solution?

2 个评论
显示无隐藏无

Soli 2014-5-26

I used the "datestr(datenum(sprintf('%d',x),'yyyymmdd'),'dd-mm-yyyy')" while x was my date vector but I got the following error. Error using datenum (line 179) DATENUM failed.

Caused by: Error using dtstr2dtnummx Failed on converting date string to date number.

Mahdi 2014-5-26

I misread your question the first time! Have you tried using the datevec MATLAB function? Basically, just input the numbers that you're getting and it should convert it to what you want if I'm understanding the question correctly.

请先登录，再进行评论。