NaN problem with xlsread

My code :

          [Day, txt_day, raw_day] = xlsread('file.xlsx',1,'A:A');
          [Paramet, txt1, raw1] = xlsread('file.xlsx',1,'F:F');

file.xlsx has Day in A column, Paramet in F.

For some day in A, some entries in F in NaN.........

I wish to plot(A,Paramet), but Paramet has lesser rows than Day, as NaN's in F are not recognized by xlsread.

I wish to plot all Day of A column, and NaN as blanka at appropriate X values

Any help.

Answer 1

[Utsav]

Luckily I got an answer clue in the link http://in.mathworks.com/matlabcentral/answers/8355-check-cell-s-contents-and-convert-to-matrix by Laura Proctor

Idea is to find character assign NaN and replace NaN values to Matrix

 ival = cellfun(@ischar,raw1);
raw1(ival) = {NaN};
Paramet_1 = cell2mat(raw1);
Paramet_2=Paramet_1(2:(numel(Day)+1),:);

Paramet_2 contains my required datasets

Thanks Laura.Thanks Mathworks.

Answer 2

[Walter Roberson]

all_day = cell2mat(raw_day);
num_day = length(all_day);

all_Paramet = cell2mat(raw1);
num_Paramet = length(all_Paramet);

if num_Paramet < num_day
  all_Paramet(end+1:num_day) = NaN;
elseif num_day < num_Paramet
  all_day(end+1:num_Paramet) = NaN;
end

plot(all_day, all_Paramet)

[Utsav]

Thanks Walter for the help...........