xlswrite over for loop

Question

adi kul 2019-12-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/495072-xlswrite-over-for-loop

编辑： meghannmarie 2019-12-5

采纳的回答： meghannmarie

在 MATLAB Online 中打开

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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

meghannmarie 2019-12-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/495072-xlswrite-over-for-loop#answer_404999

编辑：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);