How can I make .xlxs file for the following code?
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
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 comentarios
Respuestas (1)
Pulkit
el 12 de Sept. de 2022
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.
Ver también
Categorías
Más información sobre Data Import and Export en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!