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

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

Answer 1

[Sarah Wait Zaranek]

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

[H]

Thank-you very much Thomas and Sarah!

both works I will accept answer to end the question

Answer 2

[Thomas]

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