a simple question about for loop

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

[Walter Roberson]

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?

Answer 1

[Nirmal]

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

[dediydi]

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

Answer 2

[Azzi Abdelmalek]

 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