Unable to detect datetime or duration data in file for row times

TT = readtimetable('ctm.xlsx')

I tried reading the .xlsx file, but it shows the following error

Unable to detect datetime or duration data in file 'D:\Matlab codes\ctm.xlsx'

for row times

First few rows of the spreadsheet which I used is,

Time Deflection

00:00:00 0

00:00:00 2

00:00:00 4

00:00:00 8

00:00:01 16

00:00:01 32

00:00:01 64

[Peter Perkins]

Sangani, you are going to need to post the xlsx before this can be diagnosed. There are many things that could be "unusual" in your spreadsheet.

[Sangani Prithvi]

Sure Peter,

I'm attaching my xlsx file here. Please give your suggestions.

Thanks

Answer 1

[Jeremy Hughes]

Hi Sangani,

This is a consequence of how Excel stores "time" data. It represents it as a "number" internally, with a custom format that makes it look like a timestamp.

MATLAB cannot tell the difference between this and any other number with a custom format.

T = readtable('ctm.xlsx');
head(T)

ans = 8×2 table
       Time       Deflection
    __________    __________

             0         0    
             0         1    
    2.3148e-06         2    
    4.6296e-06         4    
    6.9444e-06         8    
    1.0417e-05        16    
    1.1574e-05        32    
    1.5046e-05        64    

T.Time = days(T.Time); % How Excel stores these.
T.Time.Format = "hh:mm:ss.SSS";
TT = table2timetable(T,'RowTimes','Time');
head(TT)

ans = 8×1 timetable
        Time        Deflection
    ____________    __________

    00:00:00.000         0    
    00:00:00.000         1    
    00:00:00.200         2    
    00:00:00.400         4    
    00:00:00.600         8    
    00:00:00.900        16    
    00:00:01.000        32    
    00:00:01.300        64    

[Sangani Prithvi]

Yeah, this works. Thanks a lot