MATLAB: How to store data from matlab in excel file after each iteration

Question

How to store data from matlab in excel file after each iteration rows=1:4; col=1:2; v =

     1     2
     1     3
     1     4
     2     1
     2     3
     2     4
     3     1
     3     2
     3     4
     4     1
     4     2
     4     3

Matrix A is

A=[0 1 0 1;1 0 0 0;1 0 1 0;0 0 0 1]

I want to multiply two elements of A vector each time row wise as per permutation combination of V Vector e.g. A(1st row all elements) to be multiplied by A(2nd row all elements) the code for which is

for b=1:size(v,1)
for c=1:size(v,2)-1
for i=1: size(A,1)
B=A(i,(v(b,c)))* A(i,(v(b,c+1)));
C=[B, A(i,(v(b,c))), A(i,(v(b,c+1)))];
end
end
end

I want to store values of ‘C’ every time generated in this loop in an excel file…..

Thanks

Answer 1

You first get your final matrix, say R...and use

xlswrite(filename,R)