writing and saving multiple numerical arrays to multiple excel sppreadsheets

3 visualizzazioni (ultimi 30 giorni)
HI all,
I have 300 numerical arrays named dataset1 to dataset300 in matlab and I want to save them to a folder with the same name only an .xls file instead of a .mat file. I can do this one by one, but can't seem to get a loop working to increment the xls name and copy in the next file. Any guidance is most welcome!!!!
for r=1:300; data = (eval(['datasets' num2str(r)])); xlswrite('datasets',data); %# Rename the file end end end

Risposta accettata

Azzi Abdelmalek
Azzi Abdelmalek il 14 Ott 2013
Modificato: Azzi Abdelmalek il 14 Ott 2013
for r=1:300;
file=sprintf('datasets%d.xls',r);
xlswrite(file,data);
end

Più risposte (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by