a simple question about for loop

3 vues (au cours des 30 derniers jours)
dediydi
dediydi le 19 Juil 2012
hello all,
i want to use xlswrite function in a for loop ? but i don not know how to name the variable in for
for example ;
for a = (1:10)
xlswrite( 'deneme.xls',writeEx , 1, 'A??')
end
maybe it is simple but very important for my project now. i am looking forwart to hear your answer.
thank you a lot
  1 commentaire
Walter Roberson
Walter Roberson le 19 Juil 2012
Why are you writing the same value, "writeEx", multiple times?
Is "writeEx" a scalar or a vector or a matrix? Are you trying to write it across rows or down columns or something else?

Connectez-vous pour commenter.

Réponses (2)

Nirmal
Nirmal le 19 Juil 2012
Modifié(e) : Nirmal le 19 Juil 2012
First of all its loop not loob. I hope you meant range as a variable. the following code should work.
for a = (1:10)
b=sprintf('A%i',a)
xlswrite( 'deneme.xls',writeEx , 1, b)
end
  1 commentaire
dediydi
dediydi le 19 Juil 2012
it works but not regulary. i want to start to write in excel second row. but when a = (20:50) it starts to write from 20th row. how can i fix it. thank you a lot

Connectez-vous pour commenter.


Azzi Abdelmalek
Azzi Abdelmalek le 19 Juil 2012
for i=1:10
writeEX=rand(10,10); %exemple of random matrix
xlswrite( 'deneme.xls',writeEX ,['Sht',num2str(i)],'A5')
end
% ['Sht',num2str(i)] are the sheet 1 2 3 ... named sht1 sht2 ...
% 'A5' data start at the fifth line of colon A

Catégories

En savoir plus sur Loops and Conditional Statements dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by