Import large excel file without changing datetime in Matlab-CodePudding

I want to process a monthly excel file but when using readtable, it changes the time column from HH:mm to 0.001 etc. How can I import it without changing its format?

data = readtable('Book1.xls')
d = strcat(table2array((data(:,1))), {' '}, table2array((data(:,2 ))));

CodePudding user response：

You should probably use readtable to do this. Then you can convert it correctly.

Something like this.

table= readtable('Book1.xls');

Col2 = datetime(table.Time, 'ConvertFrom','excel', 'Format','HH:mm');

Then Col2 should have the correct values