Failed on converting date string to date number
显示 更早的评论
hi all,
I have this code that I need to plot date data time vs power from excel, my code is as follow:
[num,T,vT] = xlsread('excel.xls','Sheet1'); %excel file
x = T(:,1); % Time column
y = num(:,4); % power column
% x1=datenum(0,0,0,0,x,0);
x1=datenum(x,'HH:MM');
plot(handles.axes,x1,y)
but I am getting this error:
??? DATENUM failed. Error using ==> dtstr2dtnummx Failed on converting date string to date number.
so how can I overcome this problem ??? please help..
Sam
回答（1 个）
Walter Roberson
2012-7-28
One or more of the times being input does not have the expected format.
for K = 1 : length(x)
try
x1 = datenum(x{K}, 'HH:MM');
catch
fprintf('Entry #%d is not valid, is |%s|\n', K, x{K});
end
end
6 个评论
Samer Husam
2012-7-29
Walter Roberson
2012-7-29
Odd. Could you show us
size(x)
length(x)
Samer Husam
2012-7-29
Walter Roberson
2012-7-29
What is size(x) ? If it does not have at least 35 elements then you would get that error message.
Samer Husam
2012-7-29
Walter Roberson
2012-7-29
d = size(X) returns the sizes of each dimension of array X in a vector d with ndims(X) elements. If X is a scalar, which MATLAB software regards as a 1-by-1 array, size(X) returns the vector [1 1].
类别
在 帮助中心 和 File Exchange 中查找有关 Time Series Objects 的更多信息
2012-7-28
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
