Filter löschen
Filter löschen

Problem with date fotmat from excel to Matlab

1 Ansicht (letzte 30 Tage)
Guillermo Renderos
Guillermo Renderos am 19 Mär. 2018
Kommentiert: Guillermo Renderos am 19 Mär. 2018
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 Kommentare
Von Duesenberg
Von Duesenberg am 19 Mär. 2018
Have you tried with the readtable function?
Guillermo Renderos
Guillermo Renderos am 19 Mär. 2018
Thanks!, that fix my problem.

Melden Sie sich an, um zu kommentieren.

Antworten (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by