xlswrite over for loop
2 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Risposta accettata
meghannmarie
il 5 Dic 2019
Modificato: meghannmarie
il 5 Dic 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);
0 Commenti
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!