MATLAB: Cell array into numeric array. Date data type handling.

cell arraysdates handling

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?

Best Answer

Use the modern readtable rather than the ancient xlsread. readtable parses dates properly.

Related Solutions

MATLAB: Import data from text file

use readtable which should be able to figure out the format of your file on its own. It will probably fail for your time column and import it as text instead. This can be fixed either beforehand by overriding the import options or afterward with:

yourtable.yourfirstcolumn = datetime(yourtable.yourfirstcolumn, 'InputFormat', 'HH:mm.ss.S', 'Format', 'HH:mm.ss.SSS');

MATLAB: Manipulating cells in array.

 % One of the many solutions
 t = ismember(A,'0')
 A(t)=[];

Best Answer

Related Solutions

MATLAB: Import data from text file

MATLAB: Manipulating cells in array.

Related Question