how to write data from a loop to excel file

Question

alex kariuki 2015-7-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/228924-how-to-write-data-from-a-loop-to-excel-file

编辑： bio lim 2015-7-8

在 MATLAB Online 中打开

Io=0.86;

Iv=0.43;

for theta= 0:6:360

    Imax = Io+Iv+2*cos (theta)*sqrt(Io.*Iv);
    Imin = Io+Iv-2*cos (theta)*sqrt(Io.*Iv);
    fringe_contrast =(Imax-Imin)/(Imax+Imin);
 end

how do i store the values of theta, Imax, Imin and fringe_contrast in an excel file to show all the values generated from the loop?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

bio lim 2015-7-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/228924-how-to-write-data-from-a-loop-to-excel-file#answer_185290

编辑：Stephen23 2015-7-8

在 MATLAB Online 中打开

Io=0.86;
Iv=0.43;
theta = 0:6:360; % Better use vectorization
Imax = Io+Iv+2*cos(theta) * sqrt(Io.*Iv);
Imin = Io+Iv-2*cos(theta) * sqrt(Io.*Iv);
fringe_contrast = (Imax-Imin)./(Imax+Imin); % Element-wise division
filename = 'data.xlsx';
A = {'theta','Imax','Imin','fringe_contrast'; theta.', Imax.', Imin.', fringe_contrast.'};
sheet = 1;
xlRange = 'B1';
xlswrite(filename, A, sheet, xlRange)

I don't have MATLAB installed for the laptop I am using right now, so I cannot check right now. Tell me if there is any problem.

3 个评论
显示 1更早的评论隐藏 1更早的评论

alex kariuki 2015-7-8

Thanks alot for your comments

The code you provided only writes headers to the excel file, what i was actually interested in is the for-loop. As you can see, Imax and Imin values change as i perform cos of theta (theta is angles from 0 to 360 insteps of 6 degrees).

I want to write the values of the Imax, Imin, and fringe_contrast in an excel file according to the different values of theta.

That's why i included a for-loop, may be you didn't see the loop in my question.

bio lim 2015-7-8

编辑：bio lim 2015-7-8

在 MATLAB Online 中打开

Hi Alex. Try Sid's nice corrected version.

Io=0.86;
Iv=0.43;
theta = 0:6:360; % Better use vectorization
Imax = Io+Iv+2*cos(theta) * sqrt(Io.*Iv);
Imin = Io+Iv-2*cos(theta) * sqrt(Io.*Iv);
fringe_contrast =(Imax-Imin)./(Imax+Imin); 
tableHeaders =  {'theta','Imax','Imin','fringe_contrast' };
filename = 'data.xlsx';
sheet = 1;
xlRange = 'A1';
xlswrite(filename, tableHeaders, sheet, xlRange)
 mainArrayToWrite = [theta.', Imax.', Imin.', fringe_contrast.'];
 filename = 'data.xlsx';
sheet = 1;
 xlRange = 'A2';
 xlswrite(filename, mainArrayToWrite, sheet, xlRange)