Problem with date fotmat from excel to Matlab
Show older comments
I'm working with a series of data imported to matlab from excel using the function xlsread. The data time format in excel is in dd/mm/yyyy HH:MM and I have alrady changed the format in the column of that parameter in the table that I'm using, so now the format says "Personalized". But when I open the same table in MatLab appears a number. I want to use the same format or change it to yyyy-mm-dd HH:MM but when I use the function datestr to change the number to a string, the dates are not the same (do not match with the excel ones) And when I use the syntax datestr(_, formatOut) and using the format I want, a error message appears. How can I do to fix my code or to be able to use the format I want.
2 Comments
Von Duesenberg
on 19 Mar 2018
Have you tried with the readtable function?
Guillermo Renderos
on 19 Mar 2018
Answers (0)
Categories
Find more on Time Series Objects in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!