How to read alternate rows from an excel sheet?

Hello, I am working with matlab to interpret data from excel sheets. Previously I used 'xlsread' function for reading data from a column for example * _ "t=xlsread(filename,sheet,'A2:A250')"_*.

Now I want to read data from alternate rows of a column regarding which I have no idea. I tried modifying my excel sheet but it did not work. Could anyone help me in figuring a way??

Answer 1

[Guillaume]

Yes, as per Shameer's answer, xlsread does not support reading non-continuous ranges, so you'll have to read the whole range at once.

It's just a matter of simple indexing to remove alternate rows. Do not use a loop for that:

t = xlsread(filename,sheet,'A2:A250')
toddrows = t(1:2:end, :)  
tevenrows = t(2:2:end, :)

[Aravind Rajan AYAGARA]

Voila! this method Works!!!

Thank you Mr. Guillaume

Answer 2

[Shameer Parmar]

Hello Aravind,

As per my knowledge, in xlsread, there is no such facility to fetch alternate rows of column.

You can do one thing.. after calculating value of t..

do this..

count = 1;
for i = 1:length(t)
    if rem(i,2)~=0
       new_t{count} = t{i};
       count++;
    end
end

[Aravind Rajan AYAGARA]

Thenk you for your reply, the compiler shows an error saying 'Expression or statement is incomplete or incorrect' in 'count++'

[Shameer Parmar]

ohh.. I checked and I made the changes as follows...

 count = 1;
 for i = 1:length(t)
     if rem(i,2)~=0
        new_t(count) = t(i);
        count = count + 1;
     end
 end