Failed on converting date string to date number
10 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponses (1)
Walter Roberson
le 28 Juil 2012
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 commentaires
Walter Roberson
le 29 Juil 2012
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].
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!