XLS file with a date column, the date column cannot be read correctly with MATLAB 2016a in os x (10.11.5)
1 次查看(过去 30 天)
显示 更早的评论
I have a Excel file with a date column, the date column can be read correctly with Numbers in os x (10.11.5) . However, when I open the file with 2016a, the date column is change to be 5 consecutive digits, it supposed to be mm/dd/yy. Please advise how to resolve the problem.
REMARK
=================
I open the file with MATLAB 2016a(double click with filename in MATLAB) and I did't call any command in the window.
Please refer the Excel file (the author name for documents, Dr. E.P.Chan) https://github.com/burakbayramli/kod/blob/master/books/Quantitative_Trading_Chan/IGE.xls
0 个评论
采纳的回答
Walter Roberson
2016-6-1
t = readtable('IGE.xls');
t.Date = datetime(t.Date, 'ConvertFrom', 'excel', 'Format', 'MM/dd/yy');
3 个评论
Walter Roberson
2016-6-1
You do not need datenum, datestr, or x2mdate() if you have R2014b or later.
t = readtable('IGE.xls');
t.Date = char( datetime(t.Date, 'ConvertFrom', 'excel', 'Format', 'yyyyMMdd') );
更多回答(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!