How to save the data of x (in my folowing case) to an Excel file after each loop .

I would like to save the data of x after each loop to separate column . for i =1 colums A, for i=2 colums B and so on .here is my code thank y'all

function [x,y]=trajectory1

A=linspace(-100*10^-10 ,100*10^-10,1000);

for i=1:length(A)
   x0=A(i); 

ydot0=10^6;

L1=-1*10^-10;  
t0=0;tf=12;xdot0=0;
a=L1/2;
tspan=[t0 tf]
IC=[x0,xdot0,L1,ydot0];

sdot = @(t,s) [s(2);-256*(s(1)+a)/((s(1)+a)^2+s(3)^2)^1.5-256*(s(1)-a)/((s(1)-a)^2+s(3)^2)^1.5;
        s(4);-256*s(3)/((s(1)+a)^2+s(3)^2)^1.5-256*s(3)/((s(1)-a)^2+s(3)^2)^1.5];
options=odeset('Events',@event1s)

[time,state_values]=ode45(sdot,tspan,IC,options);

x=state_values(:,1);
xdot=state_values(:,2);
y=state_values(:,3);
ydot=state_values(:,4);
figure(i)
plot(x,y);

xlswrite('data222.xls',[x]);
 

end
end

and the code for events

function [check, isterminal, direction] =event1s(t,s)
    direction=0;
    isterminal=1;
    check = s(3)>=0.5*10^-10;
    
end

[dpb]

Use writetable with the 'Range' named parameter.

You can build the range from the loop indices via num2str or sprintf

[Jon]

I am relatively new to using MATLAB Answers and am still learning the subtelties of how to best use the facility. I am curious, how do you decide whether to put your response in as as a comment rather than an answer. I would have thought perhaps the above comment could have been provided as an answer. In that case the original poster could have accepted it as answered (assuming it answered there question). Usually when I'm looking for answers I just look at questions that have an accepted answer, and this isn't possible if you enter your response as a comment. I am probably missing some subtelty here, so was interested to see if there was something deeper I'm missing.

[dpb]

Nothing subtle, no... :)

I often start with idea that initially seems like just a comment and while typing it ends up morphing into what may stand as an Answer... :) Occasionally I'll move it; generally I'd say that unless it included actual code I'd probably as here, just leave it go...

But, I can see the point you raise...in part here I figured somebody else would shortly be along and actually write code while I was being lazy...

[Jon]

Thanks for your response -makes sense

Answer 1

[Neuropragmatist]

help xlswrite and look at the 'range' option.

M.

[Phuc Deo]

how can i do that?

[Neuropragmatist]

Go to your Matlab and type:

help xlswrite

and then read what it says, paying particular attention to the section on using the 'range' option. Or do the same on this webpage:

https://uk.mathworks.com/help/matlab/ref/xlswrite.html

If you have writetable available you should use that instead as dpb suggested:

https://uk.mathworks.com/help/matlab/ref/writetable.html

The code you want might look something like this:

tablename = 'mytable.xlsx';

T1 = table(['M';'F';'M'],[45 45;41 32;40 34],{'NY';'CA';'MA'},[true;false;false]);
writetable(T1,tablename);

T2 = table(['K';'L';'P'],[55 55;51 52;50 54],{'KK';'PP';'MM'},[true;true;true]);
writetable(T2,tablename,'Range',['A' num2str(size(T1,1)+2)],'WriteVariableNames',false);