export data of a loop in different excel files
4 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Homayoon
am 27 Aug. 2015
Kommentiert: Sham Babu
am 26 Dez. 2017
Hello all-- Well it seems i face with a new problem. :-(
How can I export the data corresponding to each filenumber in my code to a different excel file?
for k = 1:10
filename = sprintf('%d.txt',k);
A = load(filename);
% doing some calculations
import output as k.xlsx
end
Well my desired outputs are 10 excel files whose names are 1.xlsx,2.xlsx and etc. Thank you so much
0 Kommentare
Akzeptierte Antwort
Stephen23
am 27 Aug. 2015
Bearbeitet: Stephen23
am 27 Aug. 2015
Try reading the documentation for xlswrite, and thinking about how you could adapt the code that I gave you earlier:
for k = 1:10
...
newfilename = sprintf('%d.xls',k);
xlswrite(newfilename,output)
end
Note that there are many options for xlswrite, so please read the documentation carefully.
2 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!