Importing data from excel

Dear all, I have a problem about importing data from Excel rows. I want to do something like this:

for i=1:10 data(i)=std(A(i):G(i)) end

-So I want to update row number too, since my data set has thousands of observations I cannot do it manually. Is it possible to do this in matlab?

Best regards, Can.

Answer 1

[Kuifeng]

%maybe the function 'size' is what you required.

 [rows cols] = size(A);
for i = 1:rows
for j = 1: cols
...
end
end

Answer 2

[Can Sever]

Thanks for your answers but I couldnt get it. What I want to do it that:

Instead of using A1:G1 and A2:G2 and so on, is there are way I can write a loop like this:

for i=1:2

do something for A(i):G(i)

end

So my problem is how to update those (i)'s in a loop in order to read data from excel.

Thanks in advance!

[Kuifeng]

 %can you describe the question with an example excel? 
%what is A(i):G(i), what is A1:G1? after 
data = importdata('abc.xls');
%it already have all rows. no loop is required