Failed on converting date string to date number
조회 수: 10 (최근 30일)
이전 댓글 표시
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
댓글 수: 0
답변 (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
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].
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!