convert excel date and time to matlab

9 views (last 30 days)
Hi,
I have read many posts about this but just cant get it to work.
I have R2014a and I'm currently using xlsread to read from an excel date and time file, which doesnt give me what I want which is to use as the time axix in plot.
Is there a way?
excel:
Capture.JPG
matlab:
Capture2.JPG
  2 Comments
Murugan C
Murugan C on 28 Jun 2019
Could pleae attach your excel sheet?
Guillaume
Guillaume on 28 Jun 2019
Edited: Guillaume on 28 Jun 2019
The simple reason that you're not getting datetime in matlab is because your date and time is not stored as date and time in Excel (well the time may be, but certainly not the date).
It looks like your date is stored as plain numbers. These can be trivially converted to date and added to the time. We would need to know which format (year-momth-day or year-day-month?) is used to give you the proper code.
An example excel file wouldn't hurt.
Finally, are you on an old version of matlab which prevent you from using the more modern readtable instead of xlsread?

Sign in to comment.

Accepted Answer

Andrei Bobrov
Andrei Bobrov on 28 Jun 2019
data = [ 9264 20180104 0.8021
9265 20180104 0.8125
9266 20180104 0.8229
9267 20180104 0.8333
9268 20180104 0.8438
9269 20180104 0.8542
9270 20180104 0.8646
9265 20180104 0.8021
9271 20180104 0.8125
9272 20180104 0.8229
9273 20180104 0.8333 ];
dateout = datetime(data(:,2),'ConvertFrom','yyyymmdd') + data(:,3);
or for old MATLAB
dateoutnum = datenum(sprintfc('%d',data(:,2)),'yyyymmdd') + data(:,3);
dateoutstr = datestr(dateoutnum);
  1 Comment
Galgool
Galgool on 28 Jun 2019
Great, it works
And how can I use it in plot for the x axis?
Its giving me an arror:
plot(dateoutstr,clos,'b')
Error using plot
Invalid first data argument

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!