Failed on converting date string to date number

4 views (last 30 days)
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);
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..

Answers (1)

Walter Roberson
Walter Roberson on 28 Jul 2012
One or more of the times being input does not have the expected format.
for K = 1 : length(x)
x1 = datenum(x{K}, 'HH:MM');
fprintf('Entry #%d is not valid, is |%s|\n', K, x{K});
Samer Husam
Samer Husam on 29 Jul 2012
what do u mean by size(x)? what is represent ?
Walter Roberson
Walter Roberson on 29 Jul 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].

Sign in to comment.


Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!