Importing data from excel

1 次查看（过去 30 天）
Can Sever
Can Sever 2016-4-9
评论： Kuifeng 2016-4-9
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.

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

回答（2 个）

Kuifeng
Kuifeng 2016-4-9
%maybe the function 'size' is what you required.
[rows cols] = size(A);
for i = 1:rows
for j = 1: cols
...
end
end
Can Sever
Can Sever 2016-4-9
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!
  1 个评论
Kuifeng
Kuifeng 2016-4-9
%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

请先登录，再进行评论。

类别

在 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