I want to store tables in a for loop to excel

Hello all

I have a force calculation of a car and get tables out for different load cases. How do I manage to store all the tables in the for loop in an excel one below the other.

for

.....

%The variable quantities that change are: Fuwf_F_V,Fuwr_F_V,Fuw_F_V,Flwf_F_V,Flwr_F_V,Flw_F_V, %Fpr_F_V,Flw_pr_F_V,Ftr_F_V

Fahrwerksstabkraefte_rear = {'Betrag';'Vektor X rear';'Vektor Y rear';'Vektor Z rear'};

Forces_rear=table(Fahrwerksstabkraefte_rear, ...

Fuwf_F_V,Fuwr_F_V,Fuw_F_V,Flwf_F_V,Flwr_F_V,Flw_F_V, Fpr_F_V,Flw_pr_F_V,Ftr_F_V);

T2=rows2vars(Forces_rear,"VariableNamesSource",'Fahrwerksstabkraefte_rear')

writetable(T2,'Forces_rear.xls');

disp('Forces Rear --> calculated and safed')

end

Matlab displays it correctly in the Command Window. It should be saved exactly below each other

Thanks for Help!

Answer 1

[J. Alex Lee]

Assuming the columns in the table are always the same, and you generate multiple versions of a table in the loop, and want to save all of them in a single excel sheet, this is how I deal with that situation in my day-to-day: store the tables in a cell array, then vertcat them all later into a single table to write to file:

N = 4
TablesCell = cell(N,1)
for i = 1:N
    tmp = array2table(rand(randi(10),5)); % generate some table
    TablesCell{i} = tmp; % save to cell array
end
T = vertcat(TablesCell{:});
writetable(T,filename)

[Christian Wetzel]

Thank you very much for the answer!The numbers are repeated in the rows of the table. In my calculation, they are different for each table.

Answer 2

[Christian Wetzel]

Thank you very much for the answer!The numbers are repeated in the rows of the table. In my calculation, they are different for each table.