Readtable() turns time stamp into decimal
8 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
I have a table with 40 columns. When I use readtable() it turns the time stamps into decimals and I don't know what the decimals mean. I need to extract the time stamps. And also I don't want the headers, but it reads them anyways.
data = readtable(filename, 'ReadVariableNames', false); %read in data file
Original excel file:
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/284580/image.jpeg)
How the data looks in matlab:
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/284581/image.jpeg)
5 comentarios
Walter Roberson
el 15 de Abr. de 2020
The numbers are fractions of a day, so you can
Time = days(FractionsOfADay);
Time.Format = 'hh:mm:ss';
Respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!