save data after each loop in next row of xlsx file

2 views (last 30 days)
Hey every body, i wrote following:
d = 3.6;
d_hinge = 3.6;
g = 9.80665;
for T = 1:2
% Relation between hinge point depth and water depth:
zeta = d_hinge./d
% Calculation of radian wave frequency omega:
omega = 2.*pi./T;
% Calculation of wave length L0(deep water):
L0 = g.*T.^2./(2.*pi);
% Naeherungsloesung nach Fenton & McKee 1990:
L = L_Fenton_McKee(L0,d);
%Calculation of Wavenumber k0:
k0 = 2*pi/L;
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
% Start of calculations needed for H_star:
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
% Calculation of R0:
R0 = R0_aus_k0(k0,d,d_hinge);
% Calculation of H_star:
H_star = H_star(R0,d_hinge);
end
Now i want to save the data after each loop into a xlsx file( after each loop a in a new row). Does anybody knows a solution?

Answers (1)

Azzi Abdelmalek
Azzi Abdelmalek on 26 Mar 2014
You can save your data in a Matrix M, then aftr the loop, save the matrix in your Excell file
xlswrite('file.xlsx',M)
  4 Comments
Azzi Abdelmalek
Azzi Abdelmalek on 26 Mar 2014
There are missing data in your code, we can't test it.

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!