how to load dates from xlsx files into matlab
3 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Ida Lunde Hygum
am 27 Mär. 2018
Beantwortet: Star Strider
am 27 Mär. 2018
Hi guys,
I am trying to load dates from an excel file into matlab, but it loads it as numbers and when I use "datestring" it turns it into dates, but starting from one day a head of original data and the year "114" instead of "2014", for example I have the original date "12/03/2014", but matlab reads it as "13-Mar-0114". My code looks like this:
datoreading=xlsread('dato.xlsx');
date_data=datestr(datoreading);
I checked that the cell in excel is in the format "Date", so this should not be the problem.
Hope somebody can help me out here! Cheers, Ida
0 Kommentare
Akzeptierte Antwort
Star Strider
am 27 Mär. 2018
Without your data to work with, we cannot troubleshoot the problem.
0 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!