how to save loop data in one excel file?

2 次查看（过去 30 天）

addy fang 2020-7-7

评论： addy fang 2020-7-7

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

madhan ravi 2020-7-7

编辑：madhan ravi 2020-7-7

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

addy fang 2020-7-7

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 2020-7-7

I figured it out. Thank you.

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

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

Translated by