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

1 次查看（过去 30 天）

显示更早的评论

Vishal Sharma 2017-1-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/322127-how-to-store-data-from-matlab-in-excel-file-after-each-iteration

评论： Vishal Sharma 2017-1-27

采纳的回答： KSSV

在 MATLAB Online 中打开

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

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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

KSSV 2017-1-27

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/322127-how-to-store-data-from-matlab-in-excel-file-after-each-iteration#answer_252198

在 MATLAB Online 中打开

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

xlswrite(filename,R)

8 个评论
显示 6更早的评论隐藏 6更早的评论

KSSV 2017-1-27

在 MATLAB Online 中打开

clc; clear all ;
A=[0 1 0 1;1 0 0 0;1 0 1 0;0 0 0 1] ;
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] ;
count = 0 ;
iwant = zeros(size(v,1)*size(v,2)-1,3) ;
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
        count = count+1 ;
        iwant(count,:) = C ;
    end
end
xlswrite('hello.xlsx',iwant)