how to save loop data in one excel file?

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);

回答(1 个)

writetable(array2table(y1, 'VariableNames', {'f', 'rl', 't'}), '\Desktop\sample.xlsx')

2 个评论

This gave the same as "xlswrite('\Desktop\sample',y1);" It only gave the last spread sheet with three columns. It should give 30 columns.
I figured it out. Thank you.

请先登录,再进行评论。

类别

帮助中心File Exchange 中查找有关 Data Import from MATLAB 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by