Importing data from excel, matlab is interpreting a time incorrectly
显示 更早的评论
I'm working on analyzing a huge amount of machine generated data, and it was all generated with time set up in this format
hours: minutes
For example '05:03.2'
When importing the data matlab is interpreting it entirely incorrectly. For some reason all of the time values (which are all different) are coming in as 42763.04ish.
All I am using for this is the [num,txt,raw] = xlsread('filename.csv'). I have not done any other processing of the data except for trying to import it. Has anyone run into this issue before? Thanks
回答(1 个)
dpb
2017-5-4
0 个投票
They're read correctly, that's just the internal representation of how Excel stores dates that isn't consistent with Matlab.
类别
在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!