Filter löschen
Filter löschen

how to save loop data in one excel file?

2 Ansichten (letzte 30 Tage)
addy fang
addy fang am 7 Jul. 2020
Kommentiert: addy fang am 7 Jul. 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);

Antworten (1)

madhan ravi
madhan ravi am 7 Jul. 2020
Bearbeitet: madhan ravi am 7 Jul. 2020
writetable(array2table(y1, 'VariableNames', {'f', 'rl', 't'}), '\Desktop\sample.xlsx')
  2 Kommentare
addy fang
addy fang am 7 Jul. 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 am 7 Jul. 2020
I figured it out. Thank you.

Melden Sie sich an, um zu kommentieren.

Community Treasure Hunt

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

Start Hunting!

Translated by