Readtable() turns time stamp into decimal
8 ビュー (過去 30 日間)
古いコメントを表示
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 件のコメント
Walter Roberson
2020 年 4 月 15 日
The numbers are fractions of a day, so you can
Time = days(FractionsOfADay);
Time.Format = 'hh:mm:ss';
回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
製品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!