Excel data to matlab
显示 更早的评论
I have excel sheet with 2 column,time and amplitude.But ,time values are in 13:25:55 format.but i couldn't import this data to matlab. error message"note that matlab numeric array can not contain strings".how to import this tipe of data to matlab.(This are GPS signal data.I want to create a signal)
13:06:35 -1.777
13:06:40 -1.934
13:06:45 -1.855
13:06:50 -1.855
13:06:55 -1.914
13:07:00 -1.855
13:07:05 -1.797
13:07:10 -1.719
13:07:15 -1.797
13:07:20 -1.699
13:07:25 -1.543
13:07:30 -1.602
13:07:35 -1.582
13:07:40 -1.68
13:07:45 -1.68
13:07:50 -1.738
13:07:55 -1.68
1 个评论
Image Analyst
2013-9-16
Is this the same as your other posting: http://www.mathworks.com/matlabcentral/answers/87321#answer_96862?
采纳的回答
Azzi Abdelmalek
2013-9-16
[v,T,vT] = xlsread('filename1.xlsx')
temps=cell2mat(vT(:,1)) % time
temps=datestr(temps,'HH:MM:SS')
valeur=cell2mat(vT(:,2)) % your value
2 个评论
mahesh chathuranga
2013-9-16
George Wood
2016-3-8
Thanks Mr. Azzi. I really appreciate your answer, very helpful.
更多回答（1 个）
David Sanchez
2013-9-16
Import your data as string using the sintax:
[num,txt] = xlsread(filename,sheet,range)
Once in Matlab, you can change the string to number.
Example:
x='10:23:34';
hour = str2num(x(1:2))
minute = str2num(x(4:5))
second = str2num(x(7:8))
Apply the code above to your needs
类别
在 帮助中心 和 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!
Translated by 
