Convert Excel date to use in MATLAB

Question

Siskia Yarzagaray 2016-5-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/284317-convert-excel-date-to-use-in-matlab

回答： Walter Roberson 2016-5-15

Halo, is there a way that I can convert the dates imported from Excel and then use this to plot graphs? The format from excel is: 11/23/2015, but MATLAB sees this as text data and I cant scatter plot it against a series of number. The error I get is: "Input arguments must be numeric".

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

Geoff Hayes 2016-5-15

Siskia - how do you want to use this date field to plot data? What is the code that you are using to read the data from file and then plot the data? What is the line of code that is generating this error? Please provide more details.

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2016-5-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/284317-convert-excel-date-to-use-in-matlab#answer_222222

If you are using R2014b or later, you can use readtable() to read the data and it will automatically convert the dates into datetime objects that can be plotted against.