Info
This question is closed. Reopen it to edit or answer.
output results to different excel sheets
2 views (last 30 days)
Show older comments
Hi I want to output my results to different excel sheets. All sheets share the same prefix plus a number to distingush them. For example,
for i = 1:5
X=y(:,i);
xlswrite('output',X,factor_i);
end
How can I make Matlab create sheets like factor_1, factor_2,...
Thanks.
0 Comments
Answers (1)
Azzi Abdelmalek
on 15 Aug 2013
Edited: Azzi Abdelmalek
on 15 Aug 2013
for i = 1:5
X=y(:,i);
xlswrite('output',X,sprintf('factor_%d',i);
end
%or you can use
strcat('factor_',num2str(i))
2 Comments
Azzi Abdelmalek
on 15 Aug 2013
Edited: Azzi Abdelmalek
on 15 Aug 2013
% sprintf('factor_%s',i) is for characters
e.g
i='r'
sprintf('factor_%s',i)
% for numbers use
i=3
sprintf('factor_%d',i)
This question is closed.
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!