writing and saving multiple numerical arrays to multiple excel sppreadsheets

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

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!