Borrar filtros
Borrar filtros

Problem with date fotmat from excel to Matlab

1 visualización (últimos 30 días)
Guillermo Renderos
Guillermo Renderos el 19 de Mzo. de 2018
Comentada: Guillermo Renderos el 19 de Mzo. de 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 comentarios
Von Duesenberg
Von Duesenberg el 19 de Mzo. de 2018
Have you tried with the readtable function?
Guillermo Renderos
Guillermo Renderos el 19 de Mzo. de 2018
Thanks!, that fix my problem.

Iniciar sesión para comentar.

Respuestas (0)

Community Treasure Hunt

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

Start Hunting!

Translated by