Problem with date fotmat from excel to Matlab
1 view (last 30 days)
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
Answers (0)
See Also
Categories
Find more on Spreadsheets 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!