Filter löschen
Filter löschen

Cell array into numeric array. Date data type handling.

2 Ansichten (letzte 30 Tage)
Patricia Alejandra Palacios Romero
Kommentiert: Peter Perkins am 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?

Melden Sie sich an, um diese Frage zu beantworten.

Akzeptierte Antwort

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

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Kategorien

Mehr zu Line Plots finden Sie in Help Center und File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by