Hi guys,
I have a for loop with two iterations, and each iteration results into a table.
I would like to know whether it is possible to store the two tables coming out of the for loop such that I do not get the table from the first iteration overwritten from the second one.
Thanks for your help in advance.

 Réponse acceptée

per isakson
per isakson le 13 Juil 2017
Modifié(e) : per isakson le 13 Juil 2017
Yes, with something like this
for jj = 1 : 2
T = something;
filename = sprintf( 'myfile_%d', jj );
writetable( T, filename )
end
if I understand your question correctly

1 commentaire

Yes, that essentially what I want. Is there a way to 'save' the results without actually saving a .txt file? Like the same way you would do it in a vector:
for i=1:2
y(i)=i+2
end

Connectez-vous pour commenter.

Plus de réponses (3)

Ok, I now understand what you want.
numIters = 3;
tables = cell(numIters,1); % A cell array to store the tables
for index = 1 : numIters
t0 = table();
tables{index} = t0;
end
Try this.
t1 = table();
t1.Name = 'My Name';
t1.Age = 89;
data = table();
data.Name = 'Your Name';
data.Age = 15;
% Append data contained in the t1 table to the data table
data = vertcat(data,t1);

2 commentaires

Konstantinos Tsitsilonis
Konstantinos Tsitsilonis le 13 Juil 2017
Modifié(e) : Konstantinos Tsitsilonis le 13 Juil 2017
Thanks for your answer Elias.
This approach shows how to store results from a for loop in one table if I understand correctly.
However, my problem is that I want each iteration to store its results in separate tables. I.e. if the for loop has 3 iterations, there should be three output tables, etc.
the statement "data = vertcat(data,t1); produced and error. Could not concatenate the table variable 'Name' using VERTCAT.
Caused by: Error using vertcat Dimensions of arrays being concatenated are not consistent.

Connectez-vous pour commenter.

Hi!
This thread is being very useful but I cannot find the way to save my tables in a excel file.
Here is the code
for jj = 1 : length(theFiles)
Table_parameters_spike = table(T,Q_spike,I_max,AT_HW,AT_RT)
filename = sprintf( 'Spike_%d', jj );
writetable(Table_parameters_spike, filename)
end
I got 5 .txt files but my objective is to get 1 .xls file with all the tables (2x5) concatenate vertically
Thanks!

1 commentaire

Daisy
Daisy le 25 Mar 2022
Hi! Did you ever manage to figure this out? I have the exact same question..

Connectez-vous pour commenter.

Catégories

En savoir plus sur Loops and Conditional Statements dans Centre d'aide et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by