MATLAB Answers

How to Save Matrices to excel multiple times with incremental excel name to avoid overwrite

3 views (last 30 days)
H
H on 11 May 2012
let C be a Matrix containing the data from matrix A and B
PROGRAM:
.
.
.
for i=1:3,
C = [A(:,i),B(:,i)];
xlswrite(C,header,colnames,'C.xls');
end
.
.
.
How would i fix xls write such that... it will have 3 Excel file saved...
i.e. C1.xls, C2.xls, C3.xls as i get the data in my "for loop"
because the syntax right now is overwriting C.xls everytime. and I end up with one excel file

  0 Comments

Sign in to comment.

Accepted Answer

Sarah Wait Zaranek
Sarah Wait Zaranek on 11 May 2012
The easier way to to construct a new filename within the loop by converting the index to a string and adding it the original name using string concatenation.
Example below ---
for ii = 1:3
filename = ['C' num2str(ii) '.xls'];
% then use filename in xlswrite call
end

  1 Comment

H
H on 11 May 2012
Thank-you very much Thomas and Sarah!
both works I will accept answer to end the question

Sign in to comment.

More Answers (1)

Thomas
Thomas on 11 May 2012
Cant test this right now, but you could try..
for ii=1:3,
C = rand(1,10); % some random data
fname=strcat('C',num2str(ii),'.','xls');
xlswrite(fname,C);
end

  0 Comments

Sign in to comment.

Products

Community Treasure Hunt

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

Start Hunting!

Translated by