I want to store tables in a for loop to excel
13 次查看(过去 30 天)
显示 更早的评论
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
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/1165248/image.png)
Matlab displays it correctly in the Command Window. It should be saved exactly below each other
Thanks for Help!
0 个评论
采纳的回答
J. Alex Lee
2022-10-22
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)
更多回答(1 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!