how to save loop data in one excel file?

1 visualizzazione (ultimi 30 giorni)
addy fang
addy fang il 7 Lug 2020
Commentato: addy fang il 7 Lug 2020
I was trying to save the following into one excel file, and do not how to do it. I only got three column data from the last sheet.
origindata=importdata(\rawdata.txt');
for t=(0.1:0.1:1)
f=origindata(:,1);
a=origindata(:,2);
b=origindata(:,3);
c=origindata(:,4);
d=origindata(:,5);
e=a-j*b;
u=c-j*d;
rl=f*0.01*t/3.*(u.*e)
plot(f,rl);
y1(:,1)=f;
y1(:,2)=rl;
y1(:,3)=t;
y1;
hold on;
end
xlswrite('\Desktop\sample',y1);

Risposte (1)

madhan ravi
madhan ravi il 7 Lug 2020
Modificato: madhan ravi il 7 Lug 2020
writetable(array2table(y1, 'VariableNames', {'f', 'rl', 't'}), '\Desktop\sample.xlsx')
  2 Commenti
addy fang
addy fang il 7 Lug 2020
This gave the same as "xlswrite('\Desktop\sample',y1);" It only gave the last spread sheet with three columns. It should give 30 columns.
addy fang
addy fang il 7 Lug 2020
I figured it out. Thank you.

Accedi per commentare.

Community Treasure Hunt

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

Start Hunting!

Translated by