How can I make .xlxs file for the following code?
2 次查看(过去 30 天)
显示 更早的评论
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
0 个评论
回答(1 个)
Pulkit
2022-9-12
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.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Import and Analysis 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!