xlswrite over for loop

2 次查看(过去 30 天)
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).

采纳的回答

meghannmarie
meghannmarie 2019-12-5
编辑:meghannmarie 2019-12-5
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);

更多回答(0 个)

标签

Community Treasure Hunt

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

Start Hunting!

Translated by