How can I make .xlxs file for the following code?

for i = 180:5:200;

for j = 0.00160:0.00001:0.00170;

for k = 0.1:0.01:1;

alp = (j)*(i)*(i)/k;

display(i); display(j); display(k);

display(alp');

end

end

end

Answer 1

[Pulkit]

It is my understanding that you want to store result variable 'alp' in Excel file. This can be done by taking a counter variable 'ctr' for storing memory address and storing alp as an array(or matrix). Then exporting 'alp' to .xlxs file using 'writematrix' command.

The following can be achieved as:

ctr=1;
for i = 180:5:200;
for j = 0.00160:0.00001:0.00170;
for k = 0.1:0.01:1;
alp(ctr) = (j)*(i)*(i)/k;
display(i); display(j); display(k);
%display(alp');
ctr=ctr+1;
end
end
end
File_Name = 'File.xlsx';
writematrix(alp',File_Name,'Sheet',1);

Please refer to the following write matrix documentation for more information on how to operate ‘writematrix’ to export matrix into different file format.

https://www.mathworks.com/help/matlab/ref/writematrix.html?searchHighlight=writematrix&s_tid=srchtitle_writematrix_1

[Mohammad Wasiq]

Thasnks for the answer I want store the result of the i j k and the alp in the xlxs file in a tabular for.