How to store vector in a loop and print into excel file all at once?

Question

Tanu Shree 2020-6-29

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/556345-how-to-store-vector-in-a-loop-and-print-into-excel-file-all-at-once

编辑： KSSV 2020-6-29

I want to write all the R at once into a excel file. I have been trying different method below loop just write the last results. Any Idea what mistake I am doing?

L = length(y_train_corr(1,:));
R = corrcoef(y_train_corr(:,2),y_train_corr(:,3));
Es = cell(L-2,1);
for i = 1:L-2
   R= corrcoef(y_train_corr(:,2),y_train_corr(:,2+i));
   Es{i} = R;
end;    
xlswrite('train_corr_coeff.xlsx',R);

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

请先登录，再进行评论。

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

Answer 1

KSSV 2020-6-29

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/556345-how-to-store-vector-in-a-loop-and-print-into-excel-file-all-at-once#answer_458428

编辑：KSSV 2020-6-29

在 MATLAB Online 中打开

You are wrtitng R in the xlswrite command. Replace R with Es.

L = length(y_train_corr(1,:));
R = corrcoef(y_train_corr(:,2),y_train_corr(:,3));
Es = cell(L-2,1);
for i = 1:L-2
   R= corrcoef(y_train_corr(:,2),y_train_corr(:,2+i));
   Es{i} = R;
end;    
xlswrite('train_corr_coeff.xlsx',Es);