writing and saving multiple numerical arrays to multiple excel sppreadsheets

3 views (last 30 days)
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

Accepted Answer

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

More Answers (0)

Community Treasure Hunt

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

Start Hunting!