Failed on converting date string to date number
2 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Risposte (1)
Walter Roberson
il 28 Lug 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 Commenti
Walter Roberson
il 29 Lug 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].
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!