How to read alternate rows from an excel sheet?

5 views (last 30 days)
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??

Answers (2)

Guillaume
Guillaume on 20 Jun 2016
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, :)

Shameer Parmar
Shameer Parmar on 20 Jun 2016
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
  2 Comments
Aravind Rajan AYAGARA
Aravind Rajan AYAGARA on 20 Jun 2016
Thenk you for your reply, the compiler shows an error saying 'Expression or statement is incomplete or incorrect' in 'count++'
Shameer Parmar
Shameer Parmar on 21 Jun 2016
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

Sign in to comment.

Tags

Community Treasure Hunt

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

Start Hunting!