xlswrite over for loop

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).

Answer 1

[meghannmarie]

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);