# save data after each loop in next row of xlsx file

1 view (last 30 days)
Chris on 26 Mar 2014
Commented: Azzi Abdelmalek on 26 Mar 2014
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?

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)
Azzi Abdelmalek on 26 Mar 2014
There are missing data in your code, we can't test it.