XLS file with a date column, the date column cannot be read correctly with MATLAB 2016a in os x (10.11.5)
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Nelson Mok
am 1 Jun. 2016
Kommentiert: Nelson Mok
am 2 Jun. 2016
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 Kommentare
Akzeptierte Antwort
Walter Roberson
am 1 Jun. 2016
t = readtable('IGE.xls');
t.Date = datetime(t.Date, 'ConvertFrom', 'excel', 'Format', 'MM/dd/yy');
3 Kommentare
Walter Roberson
am 1 Jun. 2016
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') );
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!