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

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.

Sign in to answer this question.

Products