Importing data from excel

2 views (last 30 days)
Can Sever
Can Sever on 9 Apr 2016
Commented: Kuifeng on 9 Apr 2016
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.

Answers (2)

Kuifeng on 9 Apr 2016
%maybe the function 'size' is what you required.
[rows cols] = size(A);
for i = 1:rows
for j = 1: cols

Can Sever
Can Sever on 9 Apr 2016
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)
So my problem is how to update those (i)'s in a loop in order to read data from excel.
Thanks in advance!
  1 Comment
Kuifeng on 9 Apr 2016
%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

Sign in to comment.


Find more on Data Import from MATLAB in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!