Effacer les filtres
Effacer les filtres

Cell array into numeric array. Date data type handling.

1 vue (au cours des 30 derniers jours)
Patricia Alejandra Palacios Romero
Commenté : Peter Perkins le 14 Mai 2018
I have an excel file with the collumn A full of dates of this type: 01/01/2017 00:00 for example. When I import it to MATLAB, is imported as a cell array. I need to be able to treat those cell arrays as dates in MATLA abd make conditional operations with them. Can you help in a way I can do so?

Connectez-vous pour répondre à cette question.

Réponse acceptée

Guillaume
Guillaume le 10 Mai 2018
Use the modern readtable rather than the ancient xlsread. readtable parses dates properly.
  2 commentaires
Patricia Alejandra Palacios Romero
Patricia Alejandra Palacios Romero le 11 Mai 2018
hey, thank you! that really helped me.
Peter Perkins
Peter Perkins le 14 Mai 2018
Also, probably take one extra step and use table2timetable.

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Line Plots dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by