how to load dates from xlsx files into matlab
2 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!