MATLAB: How to import date time format from excel

dateexcel

I am trying to import excel data that has a date and time stamp, but MATLAB is ignoring it. The date and time is in the A column of excel, and when I use the import data button in MATLAB it only imports the data in the B column. In the excel cell it looks like this:

2016/03/11 15:50:47.689

But the actual data in the cell is:

3/11/2016 3:50:48 PM

This also doesn't make sense because in a slightly different file with the same date format is working.

Best Answer

Use xlsread function

[num,text,both]=xlsread('yourfile.xlsx')

Related Solutions

MATLAB: Remove weekends and holidays data from excel file

% Read data 
T1 = readtable('ABC.xlsx','sheet',1) ;
T2 = readtable('ABC.xlsx','sheet',2) ;
% Get dates common in both 
idx = ismember(T1.(1),T2.(1)) ;
% Pick which are not common 
T = T1(~idx,:) ;
% write to a file 
writetable(T,'test.xlsx')

MATLAB: Xlsread not reading data.

Ask xlsread for three outputs:

[d,s,r] = xlsread('... .xlsx');

It should read everything, and you should see everything in the ‘r’ variable.

Best Answer

Related Solutions

MATLAB: Remove weekends and holidays data from excel file

MATLAB: Xlsread not reading data.

Related Question