xlswrite over for loop

1 visualización (últimos 30 días)
adi kul
adi kul el 5 de Dic. de 2019
Editada: meghannmarie el 5 de Dic. de 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).

Respuesta aceptada

meghannmarie
meghannmarie el 5 de Dic. de 2019
Editada: meghannmarie el 5 de Dic. de 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);

Más respuestas (0)

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by