writing and saving multiple numerical arrays to multiple excel sppreadsheets
3 views (last 30 days)
Show older comments
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
0 Comments
Accepted Answer
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
0 Comments
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!