How to store vector in a loop and print into excel file all at once?
1 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
KSSV
2020-6-29
编辑:KSSV
2020-6-29
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);
0 个评论
更多回答(0 个)
另请参阅
类别
在 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!