xlswrite over for loop

1 view (last 30 days)
adi kul
adi kul on 5 Dec 2019
Edited: meghannmarie on 5 Dec 2019
Hello,
I am trying to save a spreadsheet after my calculations with following code:
for j=1:numel(parameter_list)
%my code here
%% writing output
col_header={'Parameter_name','X','Y','Z'};
row_header=Batch_name;
data=[X,Y,Z];
data_cells=num2cell(data);
output_matrix=[{' '} col_header; row_header Parameter_name data_cells];
xlswrite([basefolder '\' 'resultls.xlsx'],output_matrix);
end
Now what I am getting is the last paramter details of parameter_list but I want the output to store all the values of X,Y & Z over j=1:numel(parameter_list).

Accepted Answer

meghannmarie
meghannmarie on 5 Dec 2019
Edited: meghannmarie on 5 Dec 2019
This will save out all the results in one excel:
output_mat = cell(numel(parameter_list),5);
for j=1:numel(parameter_list)
%my code here
%% writing output
row_header=Batch_name;
data=[X,Y,Z];
data_cells = num2cell(data);
output_matrix(j,:) = [row_header Parameter_name data_cells];
end
col_header={' ','Parameter_name','X','Y','Z'};
output_mat = [col_header;output_mat];
xlswrite([basefolder '\' 'resultls.xlsx'],output_matrix);

More Answers (0)

Categories

Find more on Environment and Settings in Help Center and File Exchange

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by