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

2 vues (au cours des 30 derniers jours)
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

Réponse acceptée

Sarah Wait Zaranek
Sarah Wait Zaranek le 11 Mai 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 commentaire
H
H le 11 Mai 2012
Thank-you very much Thomas and Sarah!
both works I will accept answer to end the question

Connectez-vous pour commenter.

Plus de réponses (1)

Thomas
Thomas le 11 Mai 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

Produits

Community Treasure Hunt

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

Start Hunting!

Translated by