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

excelMATLABmatrixxlswrite

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

Best Answer

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
Related Question