How can I send the MATLAB data(using loop) to excel???
显示 更早的评论
Hello. I have a touble.
I can send the MATLAB single data to excel. I studied it by this website.
But, if when the data value changes because of the loop statement,
and then how can I accumulate the all data??
For example,
for i = 1:9
A1 = randi([1 30]);
A2 = randi([1 30]);
A3 = randi([1 30]);
i = i+1
end
According the loop runs, the value of A1, A2, A3 change.
I want to get an excel file like figure below, because I want to conduct sensitivity analysis by using the accumulated data.
If another method to conduct sensitivity analysis by MATLAB,
please, give me some advices.
采纳的回答
Timo Dietz
2021-1-26
rndMatrix = zeros(9, 4); % preallocation
for i = 1:9
rndMatrix(i, 1) = i; % i
rndMatrix(i, 2) = randi([1 30]); % A1
rndMatrix(i, 3) = randi([1 30]); % A2
rndMatrix(i, 4) = randi([1 30]); % A3
end
Now, rndMAtrix contains all data.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
