MATLAB: WHY DATE CANNOT TRANSFER FROM EXCEL TO MATLAB BY XLSREAD

dateexcellreadtabletransfer dataxlsread

Hello everyone,

To the right sight in the photo is my excell origin and to your left sight is my code (of xlsread) to transfer the data from column A to D. However, the result was just from column B to D! I changed to use readtable and the notice was: "Unable to determine the format of the DATETIME data, try adding a format to the DATETIME specifier".

Could you please help me? I have tried numerous times and still unsucced, I don't know how to fix this problem.

Thank you.

Best Answer

If you have R2013b or later, use the readtable (link) function. It should automatically convert the Excel dates to MATLAB dates.

Related Solutions

MATLAB: Extract and split data from cell into multiple cells.

One approach:

C = {'07.03.2019 20:30' 'a'
     '07.03.2019 20:31' 'b'
     '07.03.2019 20:32' 'c'
     '07.03.2019 20:33' 'a'
     '07.03.2019 20:33' 'b'
     '07.03.2019 20:34' 'c'
     '07.03.2019 20:34' 'b'
     '07.03.2019 20:35' 'c'
     '07.03.2019 20:35' 'a'
     '07.03.2019 20:36' 'c'};
[U2,~,ix] = unique(C(:,2),'stable');
myNewCell = splitapply(@(x){x}, C, ix);
myNewCellA = myNewCell{1}                                     % Assign The Others Similarly, If You Want To

producing:

myNewCellA =
  3×2 cell array
    {'07.03.2019 20:30'}    {'a'}
    {'07.03.2019 20:33'}    {'a'}
    {'07.03.2019 20:35'}    {'a'}

You can always assign them as ‘myNewCellA’ and similarly for the rest, however that is ineffecient and makes it difficult to iterate through them. I would just refer to them as ‘myNewCell{1}’, ‘myNewCell{2}’, ...

MATLAB: Convert date to datetime

t = datetime(DateStrings,'InputFormat','dd/MM/yyyy');

Best Answer

Related Solutions

MATLAB: Extract and split data from cell into multiple cells.

MATLAB: Convert date to datetime

Related Question