How to read alternate rows from an excel sheet?

7 次查看（过去 30 天）
Aravind Rajan AYAGARA
评论： Shameer Parmar 2016-6-21
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??

请先登录，再回答此问题。

回答（2 个）

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

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by