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!